Return the column letter or row number

  • Thread starter Thread starter firebird96
  • Start date Start date
F

firebird96

I'm performing a lookup across multiple columns searching for a match.
Once the match is found I want to return the column letter. I'm going
to use this column letter with the indirect function to retreive data
from a cell.

How do I return the column letter, or row number, of a specific cell?

Thanks,
Kevin
 
+ Return row number:
- Active cell: "=ROW()"
- Specific cell: "=ROW(reference)" or "=CELL
("row",refernce)"

+ Return column number:
- Active cell: "=COLUMN()"
- Specific cell: "=COLUMN(reference)" or "=CELL
("col",refernce)"

-----Original Message-----

I'm performing a lookup across multiple columns searching for a match.
Once the match is found I want to return the column letter. I'm going
to use this column letter with the indirect function to retreive data
from a cell.

How do I return the column letter, or row number, of a specific cell?

Thanks,
Kevin


------------------------------------------------

~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step
Click to expand...
guide to creating financial statements
 
Back
Top