MATCH doesn't show desired result

  • Thread starter Thread starter Jeff Wright
  • Start date Start date
J

Jeff Wright

Good morning, all!

I have a cell in my Excel 2007 workbook which is dependent on the value of
cell A1. The result I want in cell A1 is either 1, 2, or zero. The formula
in cell A1 is:

=MATCH(TRUE,A2:A3)

When the values in cells A2 and A3 are FALSE, cell A1 shows a value of 2
when I expect a value of zero. Why is this?

Thanks,

Tucson Jeff
 
=IF(ISNA(MATCH(TRUE,A2:A3,0)),0,MATCH(TRUE,A2:A3,0))

Look in HELP for the meaning of the 3rd argument

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Good morning, all!
|
| I have a cell in my Excel 2007 workbook which is dependent on the value of
| cell A1. The result I want in cell A1 is either 1, 2, or zero. The formula
| in cell A1 is:
|
| =MATCH(TRUE,A2:A3)
|
| When the values in cells A2 and A3 are FALSE, cell A1 shows a value of 2
| when I expect a value of zero. Why is this?
|
| Thanks,
|
| Tucson Jeff
|
|
 
Back
Top