View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lamb Chop Lamb Chop is offline
external usenet poster
 
Posts: 38
Default How to find out the cell location

I want to find out a cell's location.

e.g. in sheet 1, A15 = "Item A"

in sheet 2, A29 ="Item A"

I want to have it in sheet 2,
B29 = "Yes, there is an same item in sheet 1"
C29 = "A15"