Hi Pete,

In Y3:

=IF(X3=Z$10,Row(),"")

Copy down as far as needed

--
Kind regards,

Niek Otten

"Pete" wrote in message
...
I need to figure out a way to look at a range of cell values (all numbers)
and return the cell number of where it falls within the list.

Reference list in Column X (X3:x25000)
# to look for in Cell Z10

Bsically if Z10 id found in X45, X76 and X5000; return 45,76,5000 in
adjacent cells.

I would like the cell #'s found to be listed next to the look for # either
in line or row format.

Does anyone have a code for this?

TIA
--
Pete