20CF-MBAC: CANCELLED: MNCPA Management & Business Advisers Conference (MBAC20)
J4. The Battle of the Lookup Functions
Speaker:
Jeff Lenning
Wed, 1:00 pm - 2:15 pm
While the iconic VLOOKUP function is probably the most popular lookup function, sometimes other options may be a better fit. Depending on the type of workbook, INDEX/MATCH or SUMIFS may offer some benefits. And, if you are using a newer version of Excel, XLOOKUP may be a wonderful alternative. Dive deep into the pros and cons of key lookup functions and when to use them.
NASBA field of study: Computer Software & Applications - Non-Technical (1.5)
Advanced search
View all CPE programs
Conference sponsorships
Reach CPAs by becoming a sponsor
Strengthen your brand recognition with a targeted buyer group – CPAs and accounting professionals. You'll interact one-on-one with informed, affluent customers.