Lookup help

  • Thread starter Thread starter wally0206
  • Start date Start date
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
 
Hi
you have to specify the 4th parameter of the VLOOKUP function. Set this
to FALSE
 
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.
 
Back
Top