Home › Practice questions › MATCH › Question 9

Excel MATCH Practice Question: Check whether the invoice number typed in E2 is in the list. Show Found if it…

By Rinkesh Shah, founder of Cellgrids.

The question

Check whether the invoice number typed in E2 is in the list. Show Found if it is and Missing if it is not, and put the result in F2.

The data

	A	E	F
1	Invoice	Check	Result
2	INV-201	INV-207	?
3	INV-202
4	INV-203
5	INV-204
6	INV-205
7	INV-206

The yellow cell is where your answer goes.

Show answer

Answer in F2: Missing

How it works

Explanation: MATCH gives a number when it finds the value and an error when it does not. ISNUMBER turns that into TRUE or FALSE, and IF turns it into a label.
Syntax: =IF(ISNUMBER(MATCH(E2,A2:A7,0)),"Found","Missing")
INV-207 is not among INV-201 to INV-206, so MATCH returns an error, ISNUMBER gives FALSE and the result is Missing.

Try it yourself in the live sheet

Type your formula in the highlighted cell and get instant feedback. Free, no Excel install needed.

Try this question in the live sheet →

MATCH syntax

=MATCH(lookup_value, lookup_array, [match_type])

Finds the position of a value within a range — usually paired with INDEX. Finding exactly where a value sits in a list, so INDEX can pull the matching row. Full MATCH guide.