Find Item in Other Column and Repeat

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Thanks! That worked really nice.

Max said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Splitting cell contents into other columns 1
mail merging filtered records..! 0
Compare two cells in two different files and return answer 6
PT Sum of Difference 2
tiny discrepancies in fixed-point numbers 3
Multi-level dependent data validation 3
Comparison of columns and calculate differences 1

Back
Top