Hi Victoria,

=INDIRECT(B6&1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Victor Delta" wrote in message
...
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