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?
Help Article Resources
Check out the Formula Handbook template!