Index formula was working. Not matching now.


=IFERROR(INDEX({LNH MASTER SHEET Neighborhood}, MATCH([Job Number]@row, {LNH MASTER SHEET Job #})), "")

It was pulling from our master sheet and has worked for weeks. Not sure what has changed.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!