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"

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"

How to find out the cell location
 

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

Stefi

€žStefi€� ezt Ã*rta:

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"

How to find out the cell location
 

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.



"Lamb Chop" wrote in message
:

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"