Help with Index/Match formula
Comments
-
I meant to remove the INDEX portion of the formula and use ONLY the MATCH portion. If that returns a #NO MATCH error, then it is not finding the data in the range on your source sheet that matches the data in your [Property Info] sheet.
Typing this out I realized the problem. When you adapted the formula, you switched the ranges.
The first range should be the range you want to pull from and the second range should be the range you are matching against.
-
gotcha. makes sense. i appreciate your help!
Have a great day!
SGF
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 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!
