Excel Help with Match Function

[jarmend]

I am using the Match() function in a spreadsheet which results in either digits or "#N/A". There are multiple cells, side-by-side, with the same formula referencing different cells. I want to then evaluate these formula results to see if any of them do result in a number instead of #N/A, but the formula does not evaluate the "#N/A" text.

Thanks in advance for any help you can offer.

 

[SkipVought]

Hi,

Not too clear! You did not include your formula. Not really sure what you are doing???

If there is no match, it returns #N/A. So I often do something like this...
[tt]
=IF(ISERROR(Match(A1,TheRange,0)),0,Index(OtherRange,Match(A1,TheRange,0),1))
[/tt]


Skip,
[sub]
[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen![/sub]

 

[KenWright]

Personally I'd use ISNA() as ISERROR() may end up hiding an error that should indeed be picked up:-

=IF(ISNA(Your_Formula),"",Your_Formula)

Regards
Ken..........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------