How could I lookup for two column data and return the other column info?

For example, I want to look up lot number and QC test ID in the table below and return test results and final disposition ready?



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!