Index Match - Just when I thought I had it figured out
So I am using a formula on a smartsheet, works flawlessly:
=IFERROR(INDEX({PERFECTION YARD CHECK TAG}, MATCH(VIN@row, {PERFECTION YARD CHECK VIN}, 0)), "")
I use it on a few different customer sheets and it works on them.
Then on one sheet - I get this error - it has to be something with how the sheet is set up I think.
Any suggestions ?
Answers
-
Double check the [VIN] column is definitely spelled to match what you have in the sheet and doesn't have any hidden spaces or anything in the column name.
-
Thank you, that did lead me in the right direction. For some reason I was not able to type in the reference data, I had to actually select the reference data from managed references. I tried pasting the formula from another page which does not work even though the references are the same destination.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!