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.
|