Hello everyone,
I have two columns that I want to return specific text. The employee names are similar but the names in the E column include an initial for their middle name. I want to compare the two employee columns and return favorite colors to the corresponding columns. Since the two employee columns aren’t the exact same, I would not know how to do that. I have attached a spreadsheet of what I am looking to do. Thanks for the help!
Have you looked into downloading fuzzy lookup? I believe it’s available for your version of excel and it sounds like it would be perfect for what you want.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Something like:Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
This formula is close to what I need but I just realized the two employee columns need to be swapped. Can you help me with the formula that shows the same thing with the columns swapped?Originally Posted by TMS
Something like:Formula:Please Login or Register to view this content.
Try this, but the second list MUST be sorted in ascending order.
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks