Copying Macro w/ different sheets

L

liseladele

I need help with a macro.

I have 5 columns and 75 rows that need a Vlookup function in them.
Each column will be using a different sheet for the Vlookup and eac
row will need a differnent column # to retrieve the data. Is there
macro I can set up to input this data??

Thanks,

Lise
 
M

Max

Perhaps a formulas approach using INDIRECT to grab
the table_array from the reference sheet would also be feasible ?

Sample construct is available at:
http://www.savefile.com/files/3504820
Vlookup different sheets n different col nums

Assume 3 reference sheets: X, Y, Z
where cols A to G contain lookup data
with col A = lookup values
data from row1 down

In another sheet: Summ,

Ref sheetnames are listed across in B1:C1, eg: X, Y, Z
(vlookup) Col #'s are listed in B2:C2 across, eg: 2, 7, 3
Lookup values are in A3 down

To retrieve the necessary from each reference sheet
for the lookup values in col A,

we could put in B3:
=VLOOKUP($A3,INDIRECT("'"&B$1&"'!A:G"),B$2,0)
and copy B3 across to D3, fill down to populate

Adapt/extend to suit ..
 
Top