Match Function

[Joe Gieder]

I use the Match Function to determine values within
another sheet on my spreadsheet, is there another
Function that could be used in its place? The problem is
that with using Match you need to enter 1, 0 or -1 I use
0 because I need to find the exact match but I don't
always get it because it finds the first match based on
the criteria what I'm looking for is not always the first
one. The formula I use is:
{=IF(ISNA(INDEX(SuppliersR,MATCH(MIN(IF((SuppliersD=$C3)*
(SuppliersS<>0),SuppliersS)),SuppliersS,),0)),0,INDEX
(SuppliersR,MATCH(MIN(IF((SuppliersD=$C3)*
(SuppliersS<>0),SuppliersS)),SuppliersS,),0))}
Can anyone help please.
Thanks in advance
Joe

 

[Paul]

I use the Match Function to determine values within
another sheet on my spreadsheet, is there another
Function that could be used in its place? The problem is
that with using Match you need to enter 1, 0 or -1 I use
0 because I need to find the exact match but I don't
always get it because it finds the first match based on
the criteria what I'm looking for is not always the first
one. The formula I use is:
{=IF(ISNA(INDEX(SuppliersR,MATCH(MIN(IF((SuppliersD=$C3)*
(SuppliersS<>0),SuppliersS)),SuppliersS,),0)),0,INDEX
(SuppliersR,MATCH(MIN(IF((SuppliersD=$C3)*
(SuppliersS<>0),SuppliersS)),SuppliersS,),0))}
Can anyone help please.
Thanks in advance
Joe

MATCH with match type parameter 0 will always return an exact match (or
#N/A). If the match you want is not the first that matches the criteria you
use, you need to specify the criteria more fully. You need to describe your
data and what you are trying to achieve before anyone can help you further.