vlookup location based on adjacent cell

[oneillp1]

Not sure how to approach this but here is the issue. I have 2 adjacent cells, the first cell will point to a worksheet in the active workbook, the second cell will point to an item to lookup. What I am trying to figure out is how i can use a formula(or VBA) that will first choose the worksheet based on the value in column A, then use a vlookup(or similar) from the value in column B.

I have attached an example of a worksheet. Any help would be greatly appreciated.

[Pete_UK]

You can use this formula:

=VLOOKUP(B2,INDIRECT("'"&A2&"'!A:B"),2,0)

then copy down as required.

Hope this helps.

Pete

[antoka05]

You could use this formula:

Please Login or Register  to view this content.

Regards,
Antonio

[antoka05]

Excuse me @Pete_UK, I gave the same answer of you but I didn't copy you.

Regards,
Antonio

[oneillp1]

Awesome thanks guys

[Pete_UK]

@Antonio,

don't worry about it. My formula is slightly different, as I included apostrophes around the sheet name.

Pete