Uploaded March 2014 | Updated September 2026, 2 hours ago

---

Some lookups can get a bit crazy. What if the lookup column and the answer column can both change? This video shows you how to create a double dynamic lookup.

(NOTE: you could put the MATCH formulas in a cell so that you can reuse them instead of repeating inside the formulas).