Monthly Archives: January 2020

You are here:

Home
2020
January

Using VLOOKUP

Excel, Google Drive, Google Sheets, Microsoft Office, VLOOKUPBy Diana January 16, 2020

XLOOKUP is a newer function that surpasses the awesomeness of VLOOKUP, but it’s only available in the Office 365 (Excel 2019) versions (and newer as they’re developed). There is still great value in VLOOKUP (and HLOOKUP as well), it just takes nesting more functions. Read the XLOOKUP post to learn more about it. Manually eyeball…

NEW! XLOOKUP

Excel, Microsoft OfficeBy Diana January 3, 2020

This is so cool. Mind Blown. XLOOKUP is conceptually similar to the other LOOKUP Functions, eXcept it doesn’t have the limitations of VLOOKUP and is easier to use! Use it in place of VLOOKUP or HLOOKUP. Default match is exact not approximate Match options are greater File_not_found options Searches a range for a match and…