If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Return the column letter or row number
+ 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 ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~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 . |
Thread Tools | |
Display Modes | |
|
|