Hi,
I know this should be simple but just can't seem to get the formula quite right and google search isn't helping.
I have a cell (say Sheet2 A1) that references a cell in another sheet (same workbook), something like:
=Sheet1!C4
It pulls back the text from that cell, the heading for a table, say "Size".
In Sheet2 A2, the cell next to the one with the simple reference formula, I'd like to display the column number for the referenced cell (Sheet1 C4) not the cell containing the reference (Sheet2 A1).
I know you can use indirect to do this when referencing cells on the same sheet, but can't seem to get it to work across worksheets.
I'm guessing I need some variation of:
=Column(Indirect(A1))
Should be simple but I can't get it to work.
Thanks for your help.
TC
Bookmarks