referencing a worksheet

  • Thread starter Thread starter Palmer, Chris
  • Start date Start date
P

Palmer, Chris

I have a spreadsheet with more than 50 worksheets on imported data with the
same basic structure. I am trying to use a combo box to select which
worksheet to look up information in. The cell references stay the same,
regardless of the sheet I am looking at. I am using the Vlookup function as
follows: Vlookup(A1,'Sample Sheet'!C$5:F$52,4,FALSE). I have a combo box
set up with the names of the different worksheets in the selection list. I
want to replace 'Sample Sheet' in the above function with a reference to the
cell where the results of the combo box are located. I have tried
EVERYTHING I can think of and I can't seem to be able to come up with the
correct way to do this. Any help would be appreciated.

Chris
 
Perhaps (not well-tested):

=VLOOKUP(A1,INDIRECT("'"&K11&"'"&"!C$5:F$52"),4,FALSE)

where K11 is the cell where the results of the ComboBox are located.
 
Worked like a charm. I just spent the last five hours on this to no avail.
Thank you very much.
 
Back
Top