Formula to return a value from another sheet based on multiple criterial


I need to pull in values to one sheet (PMT Program Filing Tracker in the screenshot) based on matching two criteria in another sheet (Program Filings in the screenshot). I’m not sure of the best formula to do this.  For example (see screenshots), in the ‘PMT Program Filing Tracker’ sheet, I need to pull in a Status from the ‘Program Filings’ sheet based on matching the “Parent Program” and “State” in the ‘Program Filings’ sheet. I’ve manually filled in the result I want the formula to return in the ‘PMT Program Filing Tracker’ Program 1 line as an example.

Thanks in advance for the help!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!