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
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 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!