| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert ADDRESS() text result to cell reference
I am using =ADDRESS(MATCH(1,E3:E5,0)+2,3) to calculate the cell reference,
but the reference is returned as text. How do I convert it to an actual reference? Leader Board Name =ADDRESS(MATCH(1,E3:E5,0)+2,3) / A B C D E 2 Tag Division Last Name Sponsor Rank 3 Y016 Youth Jackson AC Inc 2 4 A209 Adult Adams TTE 1 5 A902 Adult 2 Shepherd B&F 3 I want to see 'Adams', not the text 'C4' Thanks for any help you may be able to give me -- FirstVette52 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I convert text string into a cell reference | Excel Discussion (Misc queries) | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| reference the result of a formula in a text formatted cell | Excel Discussion (Misc queries) | |||
| How can I convert text to reference ? Ex: ISNUMBER(ADDRESS(6;10;2. | Excel Discussion (Misc queries) | |||
| Using result from ADDRESS function as a cell reference itself | Excel Worksheet Functions | |||
Threaded Mode
