IF function to find an item within a range.

[Steve-B]

Hi all,

I'd like an if function to display "Yes" when a postcode is found within a range of postcodes.

For example if I have BT23 4RE in cell b1 and a range of postcodes from say cell a1:a76 which has BT23 4RE in it, it will display yes.

[Steve-B]

I've tried

Please Login or Register  to view this content.

, yet when #n/a is returned for no match I can't get a false value to give "No".....

[sweep]

Hi,

Try this?

=IF(ISERROR(MATCH(B3,$H$3:$H$66,0)),"No","Yes")

[Steve-B]

Diolch yn fawr iawn....

Cheers Sweep....

[Steve-B]

I've since learned you can also use

Please Login or Register  to view this content.

ISNA can be used if #NA is the expected result.