Lookup Functions


I am trying to write a function to lookup and return the status of a part from another sheet. I need the function to match information from 2 cells: the project number and the part number and return the information in the status column.

Thanks in advance for your help!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!