Help with Index/Match formula
Options
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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!