While the iconic VLOOKUP function is probably the most popular lookup function, there are times when other options may be a better fit. Depending on the type of workbook, INDEX/MATCH or SUMIFS may offer some benefits. And, depending on the version of Excel you are using, XLOOKUP may be a wonderful option. Join us to learn the pros and cons of the key lookup functions and when to use each.