Help with MATCH function.

helpneeded22

Board Regular
Joined
Jan 12, 2005
Messages
51
I have the following line in my spreadsheet:

=IF(MATCH(B6,UnitDetails!A10:A109,0),"Found","Not Found")

If a match is found it does show "Match". If a match is not found, it shows #N/A

Could someome please tell me what I am doing wrong.

Thanks.
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

onlyadrafter

Well-known Member
Joined
Aug 19, 2003
Messages
5,703
Platform
  1. Windows
Hello,

How about

=IF(ISERROR((MATCH(B6,UnitDetails!A10:A109,0))),"Not Found","Found")
 

helpneeded22

Board Regular
Joined
Jan 12, 2005
Messages
51
Working now

Thanks onlyadrafter,

I was trying to find a way to use a match command to test whether the data matched data from another worksheet. I thought there should be a way of doing this without resorting to using ISNA as a default value for not found, but it is short and simple and does the trick.

Thanks.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,167
Messages
5,570,636
Members
412,334
Latest member
ExcelForLifeDontHate
Top