Finding partial matches across columns
I have two rather large columns where the second column holds partial information from the first column and I need to match them. I have tried "contains" "Has" and index match index collect and while some of the options find a result the do not find the correct result. see sample of the column info
Answers
-
What formula are you currently using and can you post some screenshots of the relevant column headers on the data sheet?
-
=IF([Shakedown List]@row = "", "", IF(HAS([Exto List]:[Exto List], [concatinating row]@row), INDEX([Exto List]:[Exto List], MATCH([concatinating row]@row, [Exto List]:[Exto List])), "Miss")), always gives me an error
=RIGHT([Shakedown List]@row, 6)
=IF([Shakedown List]@row = "", "", IF(CONTAINS([concatinating row]@row, [Exto List]:[Exto List]), INDEX([Exto List]:[Exto List], MATCH([trying stuff - right 4]@row, [Exto List]:[Exto List])), "Lost")) Gives me the rows that have matches but not the correct cell returned.
=IF([con 1]@row = "", "", [con 1]@row + [trying stuff - right 4]@row + [Con 2]@row)
-
Actually Nick I was wrong on the Right 6 formula it also gives all errors, I did have one that was halfway there but I have changed if and had a timed shut down so lost my temp file of that formula.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!