I have a list of names in a Worksheet column that are the names of worksheets
in the workbook.

For example, the column of names could start with,

BYXTRAC
GTEWKO
WERFTY
...


This formula comes close:

=(B6)&"!"&"F6"

where B6 is the worksheet name in column B6 and F6 is the cell to be
referenced in that worksheet. For example, B6 in the column list above is
BYXTRAC. So I wnat a formula to be entered in cell C6, say, in the current
worksheet that references cell F6 in the worksheet named "=B6".

The formula above yields BYXTRAC!F6, which is close but there is no equal
sign to make it a reference function. Adding the equals sign in by adding on
"="& gives the correct formula for the cell but it does not function as a
formula. It just functions as a text string.

Thanks.

John Wirt

In the old days there were reference formulas such as =@@(..).

John Wirt
In a column next to these names I want to enter a formula that looks up cell
F6 on the worksheet with the name in the column to the left.