using index match with min and using variable to loopup sheet

[bjcowen9000]

Hello,

I have 2 columns, A and B.
column A contains sheet names.
Column B contains my formula.

Here is a column B example:

Please Login or Register  to view this content.

The '0.20'! is looking up this sheet name, however, the sheet name is in column A. Instead of manually typing in each sheet name, how can I reference the cell A2 for the worksheet in the formula in B2?

[Fluff13]

Have a look at the Indirect Function

https://exceljet.net/excel-functions...irect-function