| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
function to return cell address
I have a lookup statement that looks up a date and returns info from another
column. I would like to find a function that identifies the cell where the data was found. Would I use activecell? TIA |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
function to return cell address
Hi
use the MATCH function to return the row index of the found cell -- Regards Frank Kabel Frankfurt, Germany "Papa Jonah" schrieb im Newsbeitrag ... I have a lookup statement that looks up a date and returns info from another column. I would like to find a function that identifies the cell where the data was found. Would I use activecell? TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I create a cell reference from ADDRESS function return? | Excel Worksheet Functions | |||
| Return a cell address | Excel Worksheet Functions | |||
| Address function to return values from min row | Excel Discussion (Misc queries) | |||
| How do I use a function to return the address of a cell? | Excel Worksheet Functions | |||
| Return cell address value | Excel Programming | |||
Linear Mode
