vlookup finds first match

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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.
Click to expand...
Click to expand...
 
Back
Top