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

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.

Radu
Add comment
Identify VAT rate based on country using VLOOKUP
Excel formulasLookup

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.

Radu
Add comment

Category - Lookup