Easy (hopefully) Vlookup question

[mbrs]

I have a workbook with a master sheet that draws various data from a number of other sheets within the file.

Is there a way to build a VLookup formula (without writing a massive If Then Formula) that accesses the same array within different sheets based on conditions.

Say If Cell A1 is "Jun12" A vlookup in A10 would access array A1:D200 within sheet "Jun12"

If B1 is "March12" vlookup in B10 would access array A1:D200 within sheet "March12"

Etc.

Thank you for any help in advance.

 

[Akashwani]

Hi and welcome to MrExcel.

Does this work for you?....

=VLOOKUP($A2,INDIRECT(A1 & "!$A$1:$D$200"), 3, FALSE)

This looks at the Sheet name in A1 and the lookup value in A2 and returns the data from column C (3)

I hope that helps.

Good luck.

Ak