Hi I have two columns of with a huge number of data in it.
I need to compare data in column A to the value in Column B, & see if they match.
if they match then put the comparison text into column C
Please Help....
Thanks in advance
Hi I have two columns of with a huge number of data in it.
I need to compare data in column A to the value in Column B, & see if they match.
if they match then put the comparison text into column C
Please Help....
Thanks in advance
Can you provide an example of what the correct match looks like?
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Maybe this
In C2
=VLOOKUP("*"&LEFT(B2,4)&"*",$A$2:$A$17,1,0)
A B C 1Keys Brands Match 21 million by paco Paco 1 million by paco 31 million by paco rabanne Angel 100 mls angel perfume 41 million paco Carolona Herrera 212 by carolina herrera 51 million parfum 6100 argan oil hair 7100 mls angel perfume 82 addict dior 9212 by carolina herrera 10212 by caroline herrera 11212 carolina herera 12212 carolina herrera 13212 cologne 14212 cologne men 15212 for man 16212 for men 17212 fragrance
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thanks for the reply....
You're welcome and thank you for the feedback!
Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks