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.

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" wrote:

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.

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" wrote:

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" wrote:

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.