How to find out the cell location
In B29: =IF(C29="","","Yes, there is a same item in sheet 1")
InC29: =IF(ISERROR(MATCH(A29,Sheet1!A:A,0)),"",MATCH(A29, Sheet1!A:A,0))
Regards,
Stefi
€˛Lamb Chop€¯ ezt Ć*rta:
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"
|