Blog

Are You an Excel Pro or Just Getting Started?

Lookup functions are the backbone of data analysis in Excel — whether it’s VLOOKUP, HLOOKUP, INDEX+MATCH, or the powerful XLOOKUP. These formulas help you pull data from tables, match values, and automate reports. But how well do you really know them? Excel Lookup Function Quiz

Please check out other Quizzes: –

Excel Pivot Table Quiz: Test Your Knowledge!

Excel Printing Skills with This Quick Quiz!

Take this quick 20-question quiz and find out!

1

Test Your Knowledge of Lookup Functions in Excel

Let’s see how well you know one of Excel’s most powerful features.

1 / 20

Can VLOOKUP return left column?

Yes

No

Maybe

Sometimes

2 / 20

Error if data not found?

#REF

#NAME

#N/A

#DIV/0

3 / 20

Best for two-way lookup?

INDEX + MATCH

VLOOKUP

COUNTIF

XLOOKUP

4 / 20

INDEX gets data from:

One cell

Full row

Table name

Header

5 / 20

MATCH gives?

Name

Row number

Value

Formula

6 / 20

XLOOKUP replaces?

VLOOKUP

HLOOKUP

Both

None

7 / 20

Wrong col_index causes?

#N/A

#REF!

0

Blank

8 / 20

Which function is old?

LOOKUP

XLOOKUP

INDEX

SEARCH

9 / 20

To return last match use:

HLOOKUP

VLOOKUP

XLOOKUP

SEARCH

10 / 20

‘*’ means?

Space

One letter

Any letters

Blank

11 / 20

Default match in XLOOKUP?

Approx

Exact

First

Wildcard

12 / 20

Best combo for dynamic lookup?

VLOOKUP + HLOOKUP

INDEX + MATCH

XLOOKUP + MATCH

MATCH + COUNTIF

13 / 20

VLOOKUP can’t:

Search right to right

Search right to left

Return numbers

Work with text

14 / 20

If no match, VLOOKUP shows?

#REF

#N/A

#VALUE

0

15 / 20

VLOOKUP exact match uses?

TRUE

1

FALSE

16 / 20

Which can look right to left?

VLOOKUP

XLOOKUP

HLOOKUP

LOOKUP

17 / 20

INDEX returns?

Text

Value

Cell value

Position

18 / 20

Which is new function?

VLOOKUP

HLOOKUP

XLOOKUP

FIND

19 / 20

Which searches horizontally?

VLOOKUP

INDEX

HLOOKUP

MATCH

20 / 20

What does VLOOKUP do?

Adds

Lookup

Counts

Sorts

Your score is

LinkedIn Facebook Twitter VKontakte

🔍 What’s Inside?

• 20 multiple-choice questions
• Covers VLOOKUP, HLOOKUP, XLOOKUP, INDEX, and MATCH
• Questions for all levels – beginner to expert
• Instant answers to test and improve your skills

💡 Why Take This Quiz?

Whether you’re preparing for a job interview, Excel certification, or just want to improve your spreadsheet skills, this quiz is a great way to learn by doing. Plus, it’s fun, fast, and free!