Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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" |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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" |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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" |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatic offset cell location when there is a value in a selected cell. | Excel Worksheet Functions | |||
location of cell | Excel Worksheet Functions | |||
Find & replace a value in an unknown cell location | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
How do I find the cell address of the 2nd largest of a set? | Excel Discussion (Misc queries) |