Return the column letter or row number

[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

 

[Hoang Han]

+ 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

guide to creating financial statements