Lookup function problem

  • Thread starter Thread starter sashala
  • Start date Start date
S

sashala

When using a lookup function it is repeating the final value when n
other values can be find. In other words when it can'f find an exac
match it gives the relult as the closest match. How do I tell it t
how lookup results of exact matches

Attachment filename: repeating lookup eg.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=43116
 
Hi
you have to add the 4th parameter:
=VLOOKUP(---,---,---,0)
This will look for exact matches
frank
 
Hi
yes you have to as LOOKUP does not have this 4th parameter. In your
spreadsheet in cell B15 change
=LOOKUP(A15,$A$1:$A$10,$B$1:$B$10)
to
=VLOOKUP(A15,$A$1:$A$10,$B$1:$B$10,0)
and copy down

HTH
Frank
 
Back
Top