VLOOKUP and Multiple Table_arrays.

J

JB

Hello,

I have spreadsheet with many areas, (several columns, 50 rows or so)
that are the table_arrays for VLOOKUP. In rows c10:c30 I have vlookup
formulae. What I like to do is if cell c8 contains a 1 then the
vlookup formulae would use as the table_array cells d100:g170, if cell
c8 contains a 2 then the vlookup formulae would use as the
table_array cells i100:k150, if cell c8 contains a 3 then the vlookup
formulae would use as the table_array cells m100:p150, and so on for
many table_arrays.

How would I set this up?

Thanks,
JBESr
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

trouble with (complicated) vlookup searching another workbook 2
Need Help in VLOOKUP (second attempt) 8
VLOOKUP from multiple table_arrays? 3
Using vlookup to populate multiple rows at once 6
Asking for help getting vlookup to work 4
Vlookup 4
Vlookup using a reference to a named range?(Excel 2000) 4
vlookup not working with defined name 3

Top