vlookup finds first match
 

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.

vlookup finds first match
 

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.

vlookup finds first match
 

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.