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.
