vlookup finds first match

J

Janis

This vlookup finds the first match and puts that value in every cell in the
column instead of finding all the rest of the matches in the consecutive
cells.

=VLOOKUP(AI1403,'[07-0714 Bay-Downstream Ports 98th Percentile.xls]Port
History'!$L:$M,2,FALSE)

what did I do wrong?

tia.
 
J

Janis

Hi Pranav: I found out it works after all. There was blank cells in some of
the match column. I took out all those rows and it matches. thanks,

Pranav Vaidya said:
try having the $ before and after column L and column M.

--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


Janis said:
This vlookup finds the first match and puts that value in every cell in the
column instead of finding all the rest of the matches in the consecutive
cells.

=VLOOKUP(AI1403,'[07-0714 Bay-Downstream Ports 98th Percentile.xls]Port
History'!$L:$M,2,FALSE)

what did I do wrong?

tia.
 

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