Use VLOOKUP instead...
=IF(ISNA(VLOOKUP(B5,Lookup!$A$1:$B$100,2,0)),"No
Match",VLOOKUP(B5,Lookup!$A$1:$B$100,2,0))
Hope this helps!
In article ,
"Steve Elliott" wrote:
How do I get a formula that does a standard LOOKUP, but returns an exact
match, rather than matching the nearest figure in the lookup table.
EXAMPLE:
I have a formula thus: =LOOKUP(B5,Lookup!$A$1:$A$100,Lookup!$B$1:$B$100)
However, if cell B5 contains say 1562 and the closest match in the lookup
table is 1540, then it returns the result in column B for 1540. I would
like it to return the words "No Match" if it can't find an exact match.
Any ideas?
Thanks. Steve.
|