IF formulas are extremely useful for complex decision making on a spreadsheet, but they can also be long, messy and convoluted.
This blog post explores 4 alternatives which are easier, faster and cleaner than the classic nested
VLOOKUPfor an exact match.
VLOOKUPfor a range lookup.
- The fantastic