Vlookup where range is a name ina cell

[FinancialAnalystKid]

I have groups of data in separate worksheets. In the master I have the same data and the name of the worksheet its in.

HOw can I run a vlookup to reference the worksheet based on the name in the cell?

For example. If I have a worksheet named PLAN1 in cell U2 and need to look up data in that worksheet I want my formula to work like this:

=vlookup(b2,U2&"!"$b$3:$M$1840,12,false)

The part that is bolded is the part I can't figure out where U2 is the worksheet name.

 

[Smitty]

Take a look at INDIRECT(), which will let you reference a sheet name stored in a cell.

HTH,

Smitty

 

[Aladin Akyurek]

I have groups of data in separate worksheets. In the master I have the same data and the name of the worksheet its in.

HOw can I run a vlookup to reference the worksheet based on the name in the cell?

For example. If I have a worksheet named PLAN1 in cell U2 and need to look up data in that worksheet I want my formula to work like this:

=vlookup(b2,U2&"!"$b$3:$M$1840,12,false)

The part that is bolded is the part I can't figure out where U2 is the worksheet name.

=VLOOKUP(B2,INDIRECT("'"&U2&"'!B3:M1480"),12,0)

 

[FinancialAnalystKid]

I tried Indirect

=VLOOKUP(B3,INDIRECT(U3&"!"&$B$3:$M$1840),12,FALSE)

Says it's a circular reference.

And this:

=VLOOKUP(B3,INDIRECT(U3&"!")&$B$3:$M$1840),12,FALSE)

Doesn't work.

 

[FinancialAnalystKid]

=VLOOKUP(B2,INDIRECT("'"&U2&"'!B3:M1480"),12,0)

Ahhh... I get it! THanks Aladin!!!