Cell reference

Hi,

I would to like have in CELL A1 a reference to a CELL in ROW3 but the COLUMN will be determined by the letter found in CELL B2.

For example if in cell B2 we have D then the value in CELL A1 should be D3.
If in cell B2 we have F then the value in CELL A1 should be F3

What formula do I use in CELL A1 to have such a reference?

Thanks,
Nick

hello,

use Indirect(), but be warned that it is volatile and will slow down workbooks if used in abundance

=INDIRECT(B2&"3")