Link Cell content to find the Sheet name

May 19, 2012 at 20:29:59
Specs: Windows XP
I want to use Vlookup but they need to specific the sheet name.
I want to use the Content in the field => XX1 to replace the Table Array in Vlookup
A1 = "XX1"
Sheet Name = XX1

Normal => =VLOOKUP(B5,XX1!$C$4:$D$30,2,FALSE)
I need to replace XX1 with the content in A1
if I change A1 = "XX2" that vlookup will find in Sheet XX2.
How can I do

See More: Link Cell content to find the Sheet name

Report •

May 20, 2012 at 07:51:53
Try this:

Put your Sheet Name in cell C1

DO NOT use any spaces in your sheet names.

In the formula, there are both single and double quote marks.

=VLOOKUP(A1, INDIRECT(CONCATENATE("'",$C$1,"'!$A$1:$b$500")),2,FALSE)
See how that works.


Report •
Related Solutions

Ask Question