Return column based on cell value.

[devunow]

Hi,

I wish to show a cell address whose column is determined by the value of a different cell. For instance if cell A1 has the text "d" then cell A2 would return the value of cell D2 And if the cell had the text "f" then cell A2 would return the value of F2.

Is this possible?

Also the linked cell would be on a different worksheet, does this make a difference?

Thank you so much in advance.

Dev

[Cutter]

Try

=INDIRECT("'worksheet name'!"&A1&ROW())

INDIRECT() is a volatile function so don't use a lot of them