How to find out the cell location

L

Lamb Chop

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"
 
S

Stefi

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:
 
S

Stefi

In C29: ="A"&IF(ISERROR(MATCH(A29,Munka1!A:A,0)),"",MATCH(A29,Munka1!A:A,0))

Stefi

„Stefi†ezt írta:
 
J

Jim May

In B29 enter: =IF(COUNTIF(Sheet1!A:A,"Item A")>0,"Yes, there
is...","")
In C29 enter: =IF(LEFT(B29,3)="Yes","A"&MATCH(A29,Sheet1!A:A,0))

Above will bring back the info on First instance only.
 
Top