FinancialAnalystKid
Well-known Member
- Joined
- Oct 14, 2004
- Messages
- 779
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.
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.