M
Mark
Using Excel 2007 and XP Pro SP2.
I am using a VLOOKUP formula which is working fine, however I have about 20
worksheets within my workbook each containing unique values (same data
ranges however). Is it possible to change the worksheet reference in the
example below to be a value in a column? In other words if I have columns
that represent each worksheet, can I place a cell reference in that column
to call the respective worksheet? I am looking to formulaically change the
value '220' so if I copy across it will pick up the next worksheet value of
'221', '222', '223', etc. This way I can copy that same VLOOKUP command
across a number of columns and it will automatically grab the data from that
worksheet.
This formula would reside in a separate worksheet in the same excel file.
=VLOOKUP($A8,'220'!$B$8:$C$1274,1)
So if I copy across the function would look like this for each new column:
Cell A1=VLOOKUP($A8,'221'!$B$8:$C$1274,1)
Cell B2=VLOOKUP($A8,'222'!$B$8:$C$1274,1)
Cell C2=VLOOKUP($A8,'223'!$B$8:$C$1274,1)
This would go on for about 30 columns
etc.
Thanks
Mark
I am using a VLOOKUP formula which is working fine, however I have about 20
worksheets within my workbook each containing unique values (same data
ranges however). Is it possible to change the worksheet reference in the
example below to be a value in a column? In other words if I have columns
that represent each worksheet, can I place a cell reference in that column
to call the respective worksheet? I am looking to formulaically change the
value '220' so if I copy across it will pick up the next worksheet value of
'221', '222', '223', etc. This way I can copy that same VLOOKUP command
across a number of columns and it will automatically grab the data from that
worksheet.
This formula would reside in a separate worksheet in the same excel file.
=VLOOKUP($A8,'220'!$B$8:$C$1274,1)
So if I copy across the function would look like this for each new column:
Cell A1=VLOOKUP($A8,'221'!$B$8:$C$1274,1)
Cell B2=VLOOKUP($A8,'222'!$B$8:$C$1274,1)
Cell C2=VLOOKUP($A8,'223'!$B$8:$C$1274,1)
This would go on for about 30 columns
etc.
Thanks
Mark