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