Vlookup if column A Value match with sheet name;

[iqbal88]

Hello Expert,

is it possible to do? any formula?
if column A value exactly match with the sheet name then Hlookup/Vlookup on that sheet for the value of Column B.
There have about 100 more sheets in a workbook, which should search for sheet name.


TIA,

 

[rpaulson]

=VLOOKUP(B1,INDIRECT("'"&A1&"'!"&"A:B"),2,0)

Value to lookup is in B1
Sheetname is in A1
Lookup range is A:B on the SheetName in A1

 

[iqbal88]

=VLOOKUP(B1,INDIRECT("'"&A1&"'!"&"A:B"),2,0)

Value to lookup is in B1
Sheetname is in A1
Lookup range is A:B on the SheetName in A1

Thanks