FORGET VLOOKUP XLOOKUP | DGET in Excel | Hello Excel

Описание: FORGET XLOOKUP & VLOOKUP 🤞🏼
Instead, USE DGET.
.
DGET is a database function in excel that retrieves a single value from a database.
The syntax is DGET(Database,field,criteria), wherein Database is the whole data, field is what value you want to search and criteria is on which basis you want to get your value.
.
In this example, we have a database of sales, wherein we want to get our values on the basis of Order ID.
.
Please try and share if you find it easy. 😁
.
PS:
➡️ Office 365 has been used for this example.
➡️ There can be multiple approaches to do a single thing. Hence EXAMPLES have been designed JUST TO SHOW the application of concerned topic.
.
#excel #exceltips #exceltricks #finance #spreadsheets #corporate #accounting #workhacks #tutorial #sheets #learnexcel #geekinthesheet #exceltutorial #wfh #workfromhome #commerce #tally #dynamic #google #googlesheets #excelmastery #function #dataanalysis #efficiency #dataquality #financialfreedom #spreadsheetninja #productivity #productivityhacks