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
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!