Forum Discussion
Index and Match Function With "Or" Statement
Hi All, I am trying to use the Index function to return a list of values that meet one of multiple criteria. For Example; In the file attached, if I wanted to return all the "Name" values that m...
If I understood it right, this is the formula you need in G3, copied down rows:
=LOOKUP(2,
1/(VALUE(B$3:B$17)=F3),
C$3:C$17)
Note that the values in B3:B17 are left-aligned, such that Excel reads them as text. To convert them to numbers, they are wrapped with VALUE in the lookup_vector argument of LOOKUP.
=LOOKUP(2,
1/(VALUE(B$3:B$17)=F3),
C$3:C$17)
Note that the values in B3:B17 are left-aligned, such that Excel reads them as text. To convert them to numbers, they are wrapped with VALUE in the lookup_vector argument of LOOKUP.