| 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. |
| 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 | |||
Threaded Mode
