Comparing Data in Excel - Formula Exercises with solutions

Master comparing data using Excel formulas: IF, COUNTIF, SUMIF, VLOOKUP, INDEX/MATCH through these 10 detailed exercises.

Solutions: Exercises 1 to 10
1 IF Statement
Exercise 1
Create a formula that returns "Pass" if a student's score is 50 or above, otherwise "Fail".
Difficulty: Beginner Time: ~3 minutes Skills: Conditional Logic, IF Function
Definition:

IF function: Returns one value if condition is TRUE and another if FALSE

Note: Syntax: =IF(logical_test, value_if_true, value_if_false)

Step-by-step IF method:
  1. Define the logical test (score >= 50)
  2. Specify value if true ("Pass")
  3. Specify value if false ("Fail")
  4. Enter the formula in the cell
Score Formula Result 75 =IF(A2>=50,"Pass","Fail") Pass 45 =IF(A3>=50,"Pass","Fail") Fail 60 =IF(A4>=50,"Pass","Fail") Pass
Step 1: Identify the condition

Score >= 50

Step 2: Define true/false outcomes

True: "Pass", False: "Fail"

Step 3: Write the formula

=IF(A2>=50,"Pass","Fail")

=IF(A2>=50,"Pass","Fail")
Final answer:

The formula =IF(A2>=50,"Pass","Fail") returns "Pass" for scores ≥ 50, "Fail" otherwise

Applied rules:

• Logical operators: >, <, >=, <=, =, <> for comparisons

• Text values: Enclose in double quotes

• Cell references: Use absolute ($A$1) or relative (A1) as needed

• Practice Tip: Test with boundary values (49, 50, 51) to ensure accuracy

Related Examples:
  • =IF(A1>100,"High","Low") - Compare against 100
  • =IF(B2<>"","Has Data","Empty") - Check for empty cells
  • =IF(C3=TRUE,"Active","Inactive") - Compare boolean values
Quick Tips:
  • Always use quotes for text results in IF statements
  • Test boundary conditions to ensure correct logic
  • Use F4 to toggle between absolute and relative references
Frequently Asked Questions:

Q: What if I need multiple conditions?
A: Use nested IF statements or combine with AND/OR functions.

Q: How do I compare text values?
A: Use = operator: IF(A1="Apple","Match","No Match")

2 COUNTIF Function
Exercise 2
Count how many employees have a salary greater than $50,000 in the salary range A1:A10.
Difficulty: Beginner Time: ~4 minutes Skills: Conditional Counting, COUNTIF Function
Definition:

COUNTIF function: Counts the number of cells that meet a specified criterion

Note: Syntax: =COUNTIF(range, criteria)

Step-by-step COUNTIF method:
  1. Identify the range to count (A1:A10)
  2. Define the criteria (">50000")
  3. Enter the formula to count matching cells
  4. Verify the result
Employee Salary John 45000 Jane 55000 Bob 60000 Alice 48000 Tom 70000
Step 1: Identify the range

Select the salary range (B2:B6)

Step 2: Define the criteria

Criteria: ">50000" (greater than 50,000)

Step 3: Write the formula

=COUNTIF(B2:B6,">50000")

=COUNTIF(B2:B6,">50000")
Final answer:

The formula =COUNTIF(B2:B6,">50000") counts 3 employees with salaries > $50,000

Applied rules:

• Critical syntax: Criteria must be in quotes when using operators

• Operators: >, <, >=, <=, <>, = for numeric comparisons

• Text criteria: Use wildcards * and ? for partial matches

• Practice Tip: Use COUNTIFS for multiple conditions

Related Examples:
  • =COUNTIF(A1:A10,"Apple") - Count exact matches
  • =COUNTIF(A1:A10,"*pple") - Count with wildcard
  • =COUNTIF(A1:A10,">="&B1) - Dynamic criteria
Quick Tips:
  • Always enclose operators in quotes when used alone
  • Combine operators with cell references: ">="&B1
  • Use COUNTA to count non-empty cells
Frequently Asked Questions:

Q: Can I count multiple conditions?
A: Yes, use COUNTIFS function for multiple criteria.

Q: How do I count empty cells?
A: Use COUNTBLANK(range) or COUNTIF(range,"")

3 SUMIF Function
Exercise 3
Sum the sales for the "North" region from a table with regions in column A and sales in column B.
Difficulty: Beginner Time: ~4 minutes Skills: Conditional Summing, SUMIF Function
Definition:

SUMIF function: Adds the values in a range that meet specified criteria

Note: Syntax: =SUMIF(range, criteria, [sum_range])

Step-by-step SUMIF method:
  1. Identify the range to evaluate criteria (A1:A10)
  2. Define the criteria ("North")
  3. Identify the range to sum (B1:B10)
  4. Enter the formula
Region Sales North 10000 South 15000 North 12000 East 8000 North 11000
Step 1: Identify criteria range

A2:A6 (Region column)

Step 2: Define criteria

"North"

Step 3: Identify sum range

B2:B6 (Sales column)

Step 4: Write the formula

=SUMIF(A2:A6,"North",B2:B6)

=SUMIF(A2:A6,"North",B2:B6)
Final answer:

The formula =SUMIF(A2:A6,"North",B2:B6) sums to $33,000 for North region sales

Applied rules:

• Three arguments: range, criteria, sum_range

• Same size: Criteria range and sum range must be same size

• Text criteria: Enclose in quotes

• Practice Tip: Use SUMIFS for multiple conditions

Related Examples:
  • =SUMIF(A1:A10,">100",B1:B10) - Sum where A>100
  • =SUMIF(A1:A10,"<>Complete",C1:C10) - Sum where A≠"Complete"
  • =SUMIF(A1:A10,E1,B1:B10) - Reference criteria in cell E1
Quick Tips:
  • Sum range is optional if criteria and sum ranges are the same
  • Wildcards work with text: "A*" matches entries starting with A
  • Case-insensitive by default
Frequently Asked Questions:

Q: What if I need multiple criteria?
A: Use SUMIFS function: =SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2, ...)

Q: Can SUMIF handle dates?
A: Yes! Use date criteria like ">1/1/2023" or reference date cells.

Solutions: Exercises 4 to 5
4 VLOOKUP Function
Exercise 4
Find the price of a product with ID "PROD-001" from a lookup table where column A has IDs and column B has prices.
Definition:

VLOOKUP function: Searches for a value in the first column of a table and returns a value in the same row from a specified column

Note: Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Step-by-step VLOOKUP method:
  1. Identify the lookup value ("PROD-001")
  2. Define the table array (A2:B10)
  3. Specify the column index (2 for price column)
  4. Set range lookup (FALSE for exact match)
Product ID Price PROD-001 $25.99 PROD-002 $35.50 PROD-003 $18.75 PROD-004 $42.25
Step 1: Identify lookup value

"PROD-001" or reference to cell containing it

Step 2: Define table array

A2:B5 (Product ID and Price columns)

Step 3: Specify column index

2 (second column for Price)

Step 4: Set exact match

FALSE for exact match

=VLOOKUP("PROD-001",A2:B5,2,FALSE)
Final answer:

The formula =VLOOKUP("PROD-001",A2:B5,2,FALSE) returns $25.99 for PROD-001

Applied rules:

• Lookup column: Must be the leftmost column of the table

• Column index: Count starts from the leftmost column of the table

• Exact match: Use FALSE to avoid approximate matches

• Practice Tip: Use INDEX/MATCH for more flexibility

Related Examples:
  • =VLOOKUP(A1,Sheet2!$A$1:$D$100,3,FALSE) - Cross-sheet lookup
  • =VLOOKUP(D1,A:B,2,FALSE) - Lookup in entire columns
  • =VLOOKUP(A1,$A$1:$Z$1000,COLUMN(Z1),FALSE) - Dynamic column index
Quick Tips:
  • Always use absolute references for table arrays ($A$1:$B$10)
  • Use IFERROR to handle #N/A errors gracefully
  • VLOOKUP only searches left-to-right, not right-to-left
Frequently Asked Questions:

Q: What happens if VLOOKUP doesn't find the value?
A: Returns #N/A error. Use IFERROR to handle this: =IFERROR(VLOOKUP(...),"Not Found")

Q: Can VLOOKUP look to the left?
A: No, VLOOKUP only looks right. Use INDEX/MATCH for leftward lookups.

5 INDEX/MATCH Function
Exercise 5
Find the employee name for salary $60,000 using INDEX and MATCH functions.
Definition:

INDEX/MATCH: A flexible lookup combination that finds values in any column or row

Note: Syntax: =INDEX(return_range, MATCH(lookup_value, lookup_range, 0))

Step-by-step INDEX/MATCH method:
  1. Identify the return range (names column)
  2. Identify the lookup range (salaries column)
  3. Define the lookup value (60000)
  4. Combine INDEX and MATCH functions
Employee Salary John Smith 45000 Jane Doe 60000 Bob Johnson 55000 Alice Brown 70000
Step 1: Identify return range

A2:A5 (Employee names)

Step 2: Identify lookup range

B2:B5 (Salaries)

Step 3: Define lookup value

60000

Step 4: Write the formula

=INDEX(A2:A5,MATCH(60000,B2:B5,0))

=INDEX(A2:A5,MATCH(60000,B2:B5,0))
Final answer:

The formula =INDEX(A2:A5,MATCH(60000,B2:B5,0)) returns "Jane Doe"

Applied rules:

• Flexibility: Can lookup in any direction, unlike VLOOKUP

• MATCH function: Returns position of match in range

• INDEX function: Returns value at specified position

• Practice Tip: Use 0 for exact match in MATCH function

Related Examples:
  • =INDEX(C:C,MATCH(A1,A:A,0)) - Return column C value where A=A1
  • =INDEX(B1:Z1,MATCH("Month",A1:Z1,0)) - Horizontal lookup
  • =INDEX(A:A,MATCH(MAX(B:B),B:B,0)) - Find name for max value
Quick Tips:
  • INDEX/MATCH is more flexible than VLOOKUP
  • Can perform leftward lookups that VLOOKUP cannot
  • More efficient with large datasets
Frequently Asked Questions:

Q: What's the advantage of INDEX/MATCH over VLOOKUP?
A: INDEX/MATCH can lookup in any direction, handles insertions/deletions better, and is more efficient.

Q: How do I handle multiple matches?
A: MATCH returns the first match. For subsequent matches, use array formulas or AGGREGATE.

Solutions: Exercises 6 to 10
6 Conditional Formatting
Exercise 6
Highlight cells in range A1:A10 that are greater than the average of the range.
Definition:

Conditional formatting: Automatically formats cells based on specified conditions or formulas

Note: Uses comparison operators and functions to determine formatting rules.

Step-by-step conditional formatting method:
  1. Select the range to format (A1:A10)
  2. Go to Home > Conditional Formatting > New Rule
  3. Choose "Use a formula to determine which cells to format"
  4. Enter the formula: =A1>AVERAGE($A$1:$A$10)
Value Average Status 45 52 Below Avg 58 Above Avg 62 Above Avg 48 Below Avg 57 Above Avg
Step 1: Select the range

Select A1:A10

Step 2: Access conditional formatting

Home tab > Conditional Formatting > New Rule

Step 3: Enter the formula

=A1>AVERAGE($A$1:$A$10)

Step 4: Set formatting

Choose fill color for highlighted cells

=A1>AVERAGE($A$1:$A$10)
Final answer:

Cells with values above average (52) will be highlighted using the formula =A1>AVERAGE($A$1:$A$10)

Applied rules:

• Formula approach: Use relative references for the active cell

• Absolute references: Use $ for ranges that shouldn't change

• Comparison operators: >, <, >=, <=, =, <> work in formulas

• Practice Tip: Test formulas on a single cell before applying to range

Related Examples:
  • =A1>B$1 - Compare to value in row 1
  • =MOD(ROW(),2)=0 - Format even rows
  • =COUNTIF($A$1:$A1,A1)>1 - Highlight duplicates
Quick Tips:
  • Use absolute references ($) for ranges that should remain constant
  • Relative references adjust automatically for each cell
  • Preview results before applying to large ranges
Frequently Asked Questions:

Q: How do I remove conditional formatting?
A: Select range, Home > Conditional Formatting > Clear Rules.

Q: Can I use multiple conditions?
A: Yes, create multiple rules or combine with AND/OR functions.

7 Nested IF Statements
Exercise 7
Create a grading formula that returns "A" for scores ≥90, "B" for 80-89, "C" for 70-79, and "F" for <70.
Definition:

Nested IF statements: Multiple IF functions embedded within each other to handle multiple conditions

Note: Each IF function serves as the value_if_false argument of the preceding IF function.

Step-by-step nested IF method:
  1. Start with the highest condition (score >= 90)
  2. Nest subsequent conditions in the false argument
  3. Continue nesting for all conditions
  4. End with the final else case
Score Grade 95 A 85 B 75 C 65 F
Step 1: Start with first condition

=IF(A1>=90,"A", ...)

Step 2: Add second condition

=IF(A1>=90,"A",IF(A1>=80,"B", ...))

Step 3: Continue nesting

=IF(A1>=90,"A",IF(A1>=80,"B",IF(A1>=70,"C","F")))

=IF(A1>=90,"A",IF(A1>=80,"B",IF(A1>=70,"C","F")))
Final answer:

The formula =IF(A1>=90,"A",IF(A1>=80,"B",IF(A1>=70,"C","F"))) assigns grades based on score ranges

Applied rules:

• Order matters: Test conditions from highest to lowest

• Logic flow: Once a condition is met, subsequent IFs are skipped

• Balance: Each IF needs a closing parenthesis

• Practice Tip: Consider IFS function for cleaner multiple conditions

Related Examples:
  • =IF(A1>100,"High",IF(A1>50,"Medium","Low"))
  • =IF(B1="Yes",C1*0.1,IF(B1="No",C1*0.05,0))
  • =IFS(A1>=90,"A",A1>=80,"B",A1>=70,"C",TRUE,"F") - Modern alternative
Quick Tips:
  • Keep conditions in logical order (highest to lowest or vice versa)
  • Use IFS function (Excel 2016+) for simpler syntax
  • Count parentheses to ensure they're balanced
Frequently Asked Questions:

Q: How many nested IFs can I use?
A: Up to 64 levels in modern Excel, but consider alternatives for readability.

Q: Is there a better alternative?
A: Yes, use IFS, SWITCH, or CHOOSE functions for multiple conditions.

8 AND/OR Functions
Exercise 8
Create a formula that returns "Eligible" if age ≥18 AND income ≥30000, otherwise "Not Eligible".
Definition:

AND function: Returns TRUE if all conditions are true, FALSE otherwise

OR function: Returns TRUE if any condition is true, FALSE if all are false

Note: Syntax: =AND(logical1,logical2,...) and =OR(logical1,logical2,...)

Step-by-step logical function method:
  1. Identify all conditions (age≥18, income≥30000)
  2. Wrap conditions in AND function
  3. Use result in IF statement
  4. Define true/false outcomes
Age Income Eligible 25 35000 Eligible 17 40000 Not Eligible 30 25000 Not Eligible 22 32000 Eligible
Step 1: Identify conditions

Age ≥ 18 and Income ≥ 30000

Step 2: Create AND function

AND(A2>=18,B2>=30000)

Step 3: Use in IF statement

=IF(AND(A2>=18,B2>=30000),"Eligible","Not Eligible")

=IF(AND(A2>=18,B2>=30000),"Eligible","Not Eligible")
Final answer:

The formula =IF(AND(A2>=18,B2>=30000),"Eligible","Not Eligible") checks both conditions

Applied rules:

• AND function: All conditions must be TRUE

• OR function: At least one condition must be TRUE

• Boolean results: TRUE/FALSE values returned

• Practice Tip: Combine with IF for custom outputs

Related Examples:
  • =IF(OR(A1>100,B1>100),"High Score","Normal")
  • =IF(AND(A1>50,A1<100),"Medium",IF(A1>=100,"High","Low"))
  • =AND(MOD(A1,2)=0,A1>0) - Check if positive and even
Quick Tips:
  • AND requires ALL conditions to be true
  • OR requires AT LEAST ONE condition to be true
  • Combine multiple logical functions for complex conditions
Frequently Asked Questions:

Q: Can I use AND/OR without IF?
A: Yes, they return TRUE/FALSE values directly.

Q: How do I handle more complex logic?
A: Combine AND/OR: =IF(AND(OR(A1>10,A1<5),B1>20),...)

9 Comparing Ranges
Exercise 9
Compare two ranges A1:A5 and B1:B5 and return TRUE if they contain exactly the same values in the same order.
Definition:

Range comparison: Checking if two ranges contain identical values using array formulas or helper functions

Note: Array formulas compare element-wise and return aggregate results.

Step-by-step range comparison method:
  1. Compare each element pair individually
  2. Use SUMPRODUCT to count matches
  3. Compare count to total number of elements
  4. Return TRUE if all match
A Range B Range Match Red Red Match Blue Blue Match Green Yellow No Match Yellow Yellow Match
Step 1: Compare element-wise

A1=B1, A2=B2, etc.

Step 2: Count matches

SUMPRODUCT(--(A1:A5=B1:B5))

Step 3: Compare to range size

Count matches = COUNTA(A1:A5)

Step 4: Write the formula

=SUMPRODUCT(--(A1:A5=B1:B5))=COUNTA(A1:A5)

=SUMPRODUCT(--(A1:A5=B1:B5))=COUNTA(A1:A5)
Final answer:

The formula =SUMPRODUCT(--(A1:A5=B1:B5))=COUNTA(A1:A5) returns TRUE if ranges match exactly

Applied rules:

• Array comparison: A1:A5=B1:B5 creates array of TRUE/FALSE values

• Double unary: -- converts TRUE/FALSE to 1/0

• SUMPRODUCT: Sums the converted array

• Practice Tip: Use exact match for precise comparisons

Related Examples:
  • =EXACT(A1,B1) - Case-sensitive string comparison
  • =SUMPRODUCT(--(A1:A10<>B1:B10)) - Count differences
  • =AND(A1:A5=B1:B5) - Array formula for equality (Ctrl+Shift+Enter)
Quick Tips:
  • SUMPRODUCT is non-array and easier to use
  • Use EXACT for case-sensitive text comparisons
  • Be mindful of data types when comparing
Frequently Asked Questions:

Q: What if ranges have different sizes?
A: Compare the counts first: =AND(COUNT(A1:A5)=COUNT(B1:B5),SUMPRODUCT(...)...)

Q: Does this work with numbers and text?
A: Yes, but ensure data types match between ranges.

10 Data Validation
Exercise 10
Set up data validation to allow only values between 0 and 100 in cell A1, with custom error message.
Definition:

Data validation: Restricts the type of data or the values that users can enter into a cell

Note: Helps maintain data quality by preventing invalid inputs.

Step-by-step validation setup:
  1. Select the cell(s) to validate (A1)
  2. Go to Data > Data Validation
  3. Choose "Whole Number" or "Decimal"
  4. Set criteria: Between 0 and 100
  5. Add custom input and error messages
Step 1: Select the target cell

Select cell A1

Step 2: Open Data Validation

Data tab > Data Validation

Step 3: Set validation criteria

Allow: Whole Number, Data: Between, Minimum: 0, Maximum: 100

Step 4: Customize messages

Input Message: "Enter a percentage between 0 and 100"

Error Alert: "Invalid value. Please enter a number between 0 and 100."

Validation: 0 ≤ Value ≤ 100
Final answer:

Cell A1 now accepts only values between 0 and 100 with custom validation messages

Applied rules:

• Validation types: Whole Number, Decimal, List, Date, Time, Text Length, Custom

• Criteria: Between, Not Between, Equal, Not Equal, Greater Than, Less Than

• Custom formulas: Use formulas for complex validation rules

• Practice Tip: Always test validation with boundary values

Related Examples:
  • Custom formula: =A1>B1 (value must exceed cell B1)
  • List validation: =INDIRECT("CategoryList") - dynamic dropdown
  • Date validation: =AND(A1>=DATE(2023,1,1),A1<=DATE(2023,12,31))
Quick Tips:
  • Use input messages to guide users
  • Create dropdowns with List validation
  • Custom formulas allow complex validation rules
Frequently Asked Questions:

Q: Can I validate based on another cell's value?
A: Yes, use custom formulas referencing other cells.

Q: How do I remove data validation?
A: Select the cell and click Data > Data Validation > Clear All.

Detailed Summary: Comparing Data in Excel Formulas
=IF(condition, true_value, false_value)
Basic Conditional Formula
Key definitions:

Excel formulas: Equations that perform calculations using values in cells, returning results

Logical functions: Functions that return TRUE or FALSE based on conditions (IF, AND, OR)

Lookup functions: Functions that find and retrieve specific values (VLOOKUP, INDEX/MATCH)

Complete methodology:
  1. Analyze requirements: Identify what data needs to be compared
  2. Choose appropriate function: Select IF, COUNTIF, SUMIF, VLOOKUP, etc.
  3. Construct formula: Build the formula with correct syntax
  4. Test and validate: Verify the formula works correctly with sample data
Tip 1: Use absolute references ($) when referring to fixed ranges.
Tip 2: Test boundary conditions to ensure formula accuracy.
Tip 3: Use IFERROR to handle potential errors gracefully.
Tip 4: INDEX/MATCH is more flexible than VLOOKUP.
Common errors: Incorrect cell references, mismatched parentheses, wrong comparison operators.
Best practices: Use named ranges, comment complex formulas, keep formulas simple when possible.
Formulas to memorize:

• IF statement: =IF(logical_test, value_if_true, value_if_false)

• COUNTIF: =COUNTIF(range, criteria)

• SUMIF: =SUMIF(range, criteria, sum_range)

• VLOOKUP: =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

• INDEX/MATCH: =INDEX(return_range, MATCH(lookup_value, lookup_range, match_type))

Visual Infographic: Excel Comparison Functions
IF Function: Logical Conditional logic with true/false outcomes
COUNTIF: Statistical Counts cells meeting specified criteria
SUMIF: Mathematical Sums values based on specified criteria
VLOOKUP: Lookup Finds values in vertical tables
INDEX/MATCH: Lookup Flexible lookup in any direction
AND/OR: Logical Combines multiple conditions

Key Takeaways

  • Master IF statements for basic conditional logic
  • Use COUNTIF/SUMIF for conditional counting and summing
  • Prefer INDEX/MATCH over VLOOKUP for flexibility
  • Combine AND/OR with IF for complex conditions
  • Use data validation to prevent incorrect inputs

Questions & Answers

Question: What's the difference between VLOOKUP and INDEX/MATCH, and when should I use each?

Answer: Key differences between these lookup functions:

  • VLOOKUP: Searches left-to-right only, requires lookup column to be leftmost
  • INDEX/MATCH: Can search in any direction, more flexible
  • Performance: INDEX/MATCH is generally faster with large datasets
  • Maintenance: INDEX/MATCH handles column insertions/deletions better

Use VLOOKUP for simple, left-to-right lookups in stable structures. Use INDEX/MATCH for complex lookups, when flexibility is needed, or when working with large datasets.

INDEX/MATCH is considered the modern best practice for lookups.

Question: How do I handle #N/A errors in VLOOKUP, and what are the alternatives?

Answer: Handling #N/A errors in lookups:

  • IFERROR: =IFERROR(VLOOKUP(...),"Not Found")
  • ISERROR: =IF(ISERROR(VLOOKUP(...)), "Not Found", VLOOKUP(...))
  • Modern alternative: Use XLOOKUP if available (Excel 365)
  • INDEX/MATCH: Often handles errors more gracefully

Best practice is to use IFERROR to provide meaningful messages instead of error values. Always test your lookup formulas with values that may not exist in your data source.

Consider using structured references with tables for more robust lookups.

Question: What are the best practices for creating complex nested IF statements?

Answer: Best practices for complex conditional logic:

  • Consider alternatives: Use IFS, CHOOSE, or SWITCH functions for cleaner syntax
  • Logical order: Arrange conditions from most specific to least specific
  • Formatting: Break long formulas across lines for readability
  • Testing: Validate with boundary values and edge cases

For multiple conditions, IFS function (Excel 2016+) provides cleaner syntax than nested IFs. For value mapping, consider using VLOOKUP/INDEX-MATCH with a reference table instead of complex IF statements.

Always document complex formulas with cell comments explaining the logic.

Excel Formula Glossary

Absolute Reference
A cell reference that remains constant when copied, denoted by dollar signs ($A$1).
Relative Reference
A cell reference that changes when copied to other cells (A1).
Array Formula
A formula that performs multiple calculations on one or more sets of values, entered with Ctrl+Shift+Enter.
Logical Function
Functions that return TRUE or FALSE values, such as IF, AND, OR, and NOT.
Lookup Function
Functions that search for and retrieve specific values from a table or range, like VLOOKUP, HLOOKUP, INDEX, and MATCH.

Excel Training Educational Team

Microsoft Excel Certified Trainers & Business Analysts

Our team of certified Microsoft Excel trainers and business analysts creates research-based, practical resources for data comparison and analysis. All content is aligned with Microsoft Office certification standards and reviewed by experienced professionals to ensure accuracy and pedagogical effectiveness for Excel users of all levels.