Lookup function problem

[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

 

[Frank Kabel]

Hi
you have to add the 4th parameter:
=VLOOKUP(---,---,---,0)
This will look for exact matches
frank

 

[sashala]

Do I have to use a vlookup? My spreadsheet uses just the looku
function

 

[Frank Kabel]

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