Lookup function problem

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
 
F

Frank Kabel

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top