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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 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!