MrExcel Publishing
Your One Stop for Excel Tips & Solutions

VLOOKUP Question

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

Above formula shows data from Row J

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.