How to use INDEX and MATCH functions in Excel for complex lookup

If you want to take your Excel skills to a new level, you have to learn how to use INDEX And MATCH, combine multiple functions and write complex formulas.

Identify VAT rate based on country using VLOOKUP

To identify a VAT rate based on a simple tax rate table, you can use the VLOOKUP function. For this example we have also used a Data Validation List.

Category - Lookup