View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pete Pete is offline
external usenet poster
 
Posts: 193
Default Display the Cell Number of Cell if Value =Value

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