Tagged as: index match, lookups, processes, structure, tutorials To learn more about Excel, go to the organized listing of all my Excel tutorial posts or review the most popular Excel books on Amazon . If you’re using Excel and you’ve already learned how to use INDEX MATCH, you’re well on your way to becoming proficient with Excel lookups. No matter whether you are using Excel or Google Sheets, you can use the formula same way. Here is one example to IF, INDEX and MATCH combination in Excel. Here I’ve two tables and two Index Match formulas. Formula 1 (for table 1): > =INDEX(A3:F4,M Learn how to use INDEX and MATCH worksheet functions in Excel VBA. You can utilize the built-in Excel Worksheet functions such as the VLOOKUP Function, the CHOOSE Function and the PMT Function in your VBA code and applications as well.