How do I write an Index/Match formula that pulls an EXACT match?
Ami Veltrie
✭✭✭✭✭✭
I'm pulling data into a sheet using a cross sheet Index/Match. However the formula is stopping at the first 'match' (from source sheet) and not finding the exact match. Therefore resulting in the wrong "Avi ID".
For example:
Account Name #1: Acme, Inc
Account Name #2: Acme, Inc. - Canada
=IF([Account Name]@row = "", "", INDEX({SF Account and Avi Customer Names-Avi ID}, MATCH([Account Name]@row, {SF Account and Avi Customer Names-AccountNameSF}, 0)))
Best Answer
-
Please disregard this. I figured out it was a different issue, not the formula.
Answers
-
Please disregard this. I figured out it was a different issue, not the formula.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!