VLOOKUP Question


Posted by Rick on March 28, 2001 2:09 PM

=IF(A2<>"",VLOOKUP($A2,$J$1:$L$6,2,FALSE),"")
Above formula shows data from Row J

=IF(A2<>"",VLOOKUP($A2,$J$1:$L$63,3,FALSE),"")
Above formula shows data from Row K

How in the heck would I do a VLOOKUP to also capture
data from 2 additional Rows(Like Row L & M)?

This one has totally stumped me!!
Thanks in Advance!



Posted by Mark W. on March 28, 2001 2:12 PM

Rick, rows are labelled with numbers. Columns are
labelled with alphabetic characters unless the R1C1
reference style is in use.