MATCH doesn't show desired result

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff Wright - 21 Dec 2007 12:26 GMT

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

Reply to this Message

Niek Otten - 21 Dec 2007 12:44 GMT

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

Look in HELP for the meaning of the 3rd argument

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Good morning, all!
|
[quoted text clipped - 10 lines]
|
| Tucson Jeff

Reply to this Message

Jeff Wright - 21 Dec 2007 12:55 GMT

Thanks, Niek! I appreciate your help.

Tucson, Jeff

> =IF(ISNA(MATCH(TRUE,A2:A3,0)),0,MATCH(TRUE,A2:A3,0))
>
[quoted text clipped - 16 lines]
> |
> | Tucson Jeff

Reply to this Message