Multiple VLOOKUPS in one formula?

Is it possible to create a formula that has multiple vlookups from different references?

If so, how? I've tried, unsuccessfully.

My goal is to create a formula that tracks the most recent number in a cell aug -10, sept-20, oct - "blank" so the cell will show 20. We have 4 sheets that track this info on a quarterly basis (q1 - aug, sept, oct), so i'd need this formula to take the most recently updated field across multiple sheet references. is this possible?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!