#shorts
My Digital Quill | Excel Formulas and Functions #6 | DGET function in Excel 365 | Excel tips and tricks | Excel #shorts
The example cited in this video utilizes DGET function for multiple criteria. This database function is a better alternate for VLOOKUP function in two ways. Firstly, it looks up values based on multiple criteria and secondly, it can lookup a value to the left of the look up range. Be careful while using the header of this function in the lookup range as your heading has to align with your database headings other wise Excel will land you a hashtag error.
You can use this example to pull up any data from a table array structure.
Credits:
Thumbnail Photo by Mikhail Nilov from Pexels
Idea by Contextures Inc. in • Use Excel's MATCH Function With VLOOKUP
Please check out more Excel tips and tricks from the playlist link down below:
• Excel Tips and Tricks
Check this playlist for Excel formulas and functions:
• Excel Formulas and Functions Series
Free Excel Course available on formatting techniques in here:
• Excel Formatting Techniques
🔔 Subscribe for free Office Tutorials at My Digital Quill:
/ @mydigitalquill8945
#DGETfunction #DGETformultiplecriteria #DGETfunctioninExcel #Excelformulasandfunctions #Exceltipsand tricks #Excelshorts
#MyDigitalQuill