View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Walter Walter is offline
external usenet poster
 
Posts: 78
Default 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.