Returning Data with a formula

Options
Debbie Petersen
Debbie Petersen ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Boy have I gone round and round with this!  This formula is meant to bring back the data from another sheet based on the code entered (ie: code - CALVE and it should return the full name, email of that company from a different sheet).  Sometimes this formula works perfect and other times it brings back the wrong company?  Can NOT figure this out?  Anyone see the problem here in this formula?

=INDEX({Sub Company}, MATCH(Code@row, {Sub Code}, 1))

 

TIA!

Debbie

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!