ExcelBanter - function to return cell address

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - function to return cell address (https://www.excelbanter.com/excel-programming/317412-function-return-cell-address.html)

Papa Jonah

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

Frank Kabel

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

All times are GMT +1. The time now is 07:21 PM.