The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

DATEDIF (), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000. It's fallen off current Excel menus, but you can still use it.

A little from column A, a little from column B: XLOOKUP is the new, easier way to retrieve information across Excel spreadsheets.

Excel’s Date & Time functions ease the workload for bookkeepers, project planners, HR departments, and other jobs where time is money. The four functions covered here—ISOWEEKNUM, WEEKNUM ...

A combo box's autocomplete feature linked to a lookup function creates a flexible search tool.

I am running into the dreaded "Excel cannot complete this task with available resources" dialog box in Excel while trying to fill a column with a simple VLOOKUP equation. I have one column with ...

Excel groups functions into 12 categories: Compatibility, Cube, Database, Date and Time, Engineering, Financial, Information, Logical, Lookup & Reference, Math & Trigonometry, Statistical and Text.