LinkBack URL
About LinkBacks
How do I compare Col1 1 in Col 2 and display results in third column
Col1
Apple
Mango
Banana
Berry
Peach
Col2
This is a Banana
Apple is good
Blue Berry is Amazing
Peach is good for health
Fruits are great
Result
Banana
Apple
Berry
Peach
No match
How do I compare Col1 1 in Col 2 and display results in third column
Col1
Apple
Mango
Banana
Berry
Peach
Col2
This is a Banana
Apple is good
Blue Berry is Amazing
Peach is good for health
Fruits are great
Result
Banana
Apple
Berry
Peach
No match
Last edited by s_anr; 03-20-2013 at 04:32 PM.
Can you upload the actual data you are working on or is that the above info?
Its almost the same data. Just that the words change. Only two columns. I can't do a vlookup as column two will not exactly match column one. Its like a simple FIND of each value in column and find it in all rows of column B>
=IFERROR(LOOKUP(1E99,SEARCH(A$1:A$5,B1),A$1:A$5),"No match")
Copy down
See the attached
Thank you mama. You know the best!!
Last edited by s_anr; 03-21-2013 at 12:59 AM.
You're Welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks