| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
return the Cell address of a value
Column C Column D
Age 3 Column A Column B 1 0.001 I would like to look up the value column A that matches 2 0.002 the value in Column D (3) and display the result as the cell 3 0.003 address 4 0.004 I'm using Excel 2007 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
return the Cell address of a value
Try this...
Assuming the data in column A is in the range A3:A100. =ADDRESS(MATCH(D2,A3:A100,0)+ROW(A3)-1,COLUMN(A3),4) -- Biff Microsoft Excel MVP "Jack_442" wrote in message ... Column C Column D Age 3 Column A Column B 1 0.001 I would like to look up the value column A that matches 2 0.002 the value in Column D (3) and display the result as the cell 3 0.003 address 4 0.004 I'm using Excel 2007 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
return the Cell address of a value
Thank you this works
"T. Valko" wrote: Try this... Assuming the data in column A is in the range A3:A100. =ADDRESS(MATCH(D2,A3:A100,0)+ROW(A3)-1,COLUMN(A3),4) -- Biff Microsoft Excel MVP "Jack_442" wrote in message ... Column C Column D Age 3 Column A Column B 1 0.001 I would like to look up the value column A that matches 2 0.002 the value in Column D (3) and display the result as the cell 3 0.003 address 4 0.004 I'm using Excel 2007 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
return the Cell address of a value
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Jack_442" wrote in message ... Thank you this works "T. Valko" wrote: Try this... Assuming the data in column A is in the range A3:A100. =ADDRESS(MATCH(D2,A3:A100,0)+ROW(A3)-1,COLUMN(A3),4) -- Biff Microsoft Excel MVP "Jack_442" wrote in message ... Column C Column D Age 3 Column A Column B 1 0.001 I would like to look up the value column A that matches 2 0.002 the value in Column D (3) and display the result as the cell 3 0.003 address 4 0.004 I'm using Excel 2007 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| USING VLOOKUP TO RETURN A CELL ADDRESS | Excel Worksheet Functions | |||
| Return a cell address | Excel Worksheet Functions | |||
| LOOKUP & RETURN CELL ADDRESS | Excel Worksheet Functions | |||
| Lookup, and Return Cell Address | Excel Worksheet Functions | |||
| V Lookup and return cell address | Excel Worksheet Functions | |||
Linear Mode
