Lookup help

W

wally0206

when i do a lookup and i type a number to find that deoen't exsit in th
table it still retruns a value to the nearest number i want it to sho
N/A instead. thanks for any info
 
K

kkknie

Assuming you have:

=LOOKUP(A1,RANGE1,RANGE2)

You can use

=IF(A1=LOOKUP(A1,RANGE1,RANGE1),LOOKUP(A1,RANGE1,RANGE2),"N/A")

Even better, use VLOOKUP (search for its syntax in Help). It allow
you to decide whether you want an approximate or exact lookup in it
4th parameter.
 
Top