Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Item in Other Column and Repeat
Col A Col B
abcd1234 mnop3456 efgh5678 qrst7890 ijkl9012 kkkk1111 mnop3456 qrst7890 Col A already exists and I want to take first item in Col B and search all of Col A for that item. If it does not exist, return either a "no" or a "0". If it does exist, I want to know where it is in Col A so I guess that I need the cell location returned. All returns can be returned to the next column over next to the item I am searching for Then move to the second item in Col B and search all of Col A again for that item with same results, Then move to third item in Col B and so forth. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Item in Other Column and Repeat
One way ..
In C1: =IF(ISNUMBER(MATCH(B1,A:A,0)),"A"&MATCH(B1,A:A,0), "no") Copy down to last row of data in col B -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Walter" wrote: Col A Col B abcd1234 mnop3456 efgh5678 qrst7890 ijkl9012 kkkk1111 mnop3456 qrst7890 Col A already exists and I want to take first item in Col B and search all of Col A for that item. If it does not exist, return either a "no" or a "0". If it does exist, I want to know where it is in Col A so I guess that I need the cell location returned. All returns can be returned to the next column over next to the item I am searching for Then move to the second item in Col B and search all of Col A again for that item with same results, Then move to third item in Col B and so forth. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Item in Other Column and Repeat
Thanks! That worked really nice.
"Max" wrote: One way .. In C1: =IF(ISNUMBER(MATCH(B1,A:A,0)),"A"&MATCH(B1,A:A,0), "no") Copy down to last row of data in col B -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Walter" wrote: Col A Col B abcd1234 mnop3456 efgh5678 qrst7890 ijkl9012 kkkk1111 mnop3456 qrst7890 Col A already exists and I want to take first item in Col B and search all of Col A for that item. If it does not exist, return either a "no" or a "0". If it does exist, I want to know where it is in Col A so I guess that I need the cell location returned. All returns can be returned to the next column over next to the item I am searching for Then move to the second item in Col B and search all of Col A again for that item with same results, Then move to third item in Col B and so forth. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Item in Other Column and Repeat
welcome. good to hear that.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Walter" wrote in message ... Thanks! That worked really nice. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I repeat an item in multiple formulas w/out retyping each | Excel Worksheet Functions | |||
Can Excel find & sort one item in all the cells in a column? | New Users to Excel | |||
How do I tell Excel to find the last item in a column? | Excel Discussion (Misc queries) | |||
How I can print full text bigger than column, in repeat column | Excel Discussion (Misc queries) | |||
find previous row for an item | Excel Worksheet Functions |