=MATCH question

[Met Fan]

I have the following formula in a spreadsheet:

=MATCH(F4,$B$4:$B$100,0)

The formula works fine, but when there is not a match the result is #N/A.

Is there a way I can format this not so show either using conditional formatting of an IF statement before the formula?

Thanks

 

[Andrew Poulsom]

One way:

=IF(ISNA(MATCH(F4,$B$4:$B$100,0)),"",MATCH(F4,$B$4:$B$100,0))

 

[fridgenep]

other way...

Hi,

=If(Countif($B$4:$B$100,$F$4),MATCH(F4,$B$4:$B$100,0),"")

 

[Met Fan]

Thanks - that did the trick