Formula Issue
Options
We are having trouble with the rows below the first indent. Here is the formula =INDEX({SCOLO Int. TypeGadget Group Lookup Range 1}, MATCH([LO Template]@row, {SCOLO Int. TypeGadget Group Lookup Range 2}))
This is correct but once we get to the lower rows the gadget group it is pulling in is incorrect
Here is a copy of the reference sheet
Thanks for any help  I think I has something to do with the indent but I editted it and that did not help
Answers

=INDEX({SCOLO Int. TypeGadget Group Lookup Range 1}, MATCH([LO Template]@row, {SCOLO Int. TypeGadget Group Lookup Range 2},0
Always put a ,0 if you are looking for an exact match in unsorted data
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!