Module 22 : DGET Function

22.1 DGET Function The DGET function in Excel can be used to extract a single value from a database or list column that matches the conditions you set. DGET will return a #VALUE! error if there is no match, and a #NUM! error if there is more than one match. The formula is written as: =DGET(database, field, criteria) Database - This is the range of cells that make up your database or list. Field - This is the column that you would like to return data from. You can either ...

Lessons

Find out how we can help train your staff

Or buy an individual course