Hi

Can anyone help me with this please? I'm usually ok finding the right
functions to do what I want in Excel but, so far, this one has eluded me. I
suspect there may be a simple answer...?

I have a cell in a sheet, say B6, which contains a column address, say AE.

All I am trying to so, is create a formula in another cell (say D9) which
will yield the contents of cell AE1 - i.e. the cell in row 1 and the column
indicated by the contents of B6.

Any suggestions please?

Many thanks,

V