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
 
Top