#Excel_Tutorial#DGET_Excel#Excel#DGET_Learn_Excel# Function#DGET_Function The DGET function is one of the most important lookup functions in Excel, which competes with some famous functions such as the VLOOKUP function. In this video, we will explain the DGET function and its strengths, such as searching to the left of the value and also searching with more than one condition. To download the work file: http://bit.ly/3cVxdax Previous videos Explanation of using the Hlookup function with Match in Excel How to use Hlookup with Match in Excel • Explanation of the HLOOKUP horizontal lookup function in Excel • Explanation of the Slicer tool Advanced filter tool in Excel • Explanation of the Slicer tool Advanced filter tool in Excel A detailed explanation of the survey chart in Excel How to create a survey chart in excel • How to draw a survey chart ... Function to calculate the number of days in a month in Excel Excel Function to Count Days in Each Month • Function to calculate the number of days in a month in Excel ... Explanation of the TRIM function and how to use it with the VLOOKUP function • Explanation of the TRIM function and how to use it with the D... Text Function in Excel Function to convert numeric values ​​in Excel • Text Function in Excel Function to convert ... Cell Reference In Excel Explanation of reference cells in Excel • Learn how to fix the cell in Excel while writing ... Consolidation Merging and grouping data in more than one sheet in Excel • Consolidation Merging and grouping data ... Protect Worksheet Protect a worksheet in Excel • How to protect a worksheet in Excel Exce... Subtotal Subtotal tool in Excel - Excel Online • Subtotal Subtotal tool in ... Advanced features and advantages of tables in Excel Excel Online • The importance of using Excel tables dynamically ... Features and advantages of tables in Excel Tables Features in Excel • The most important features of tables in Excel ... Using CountIF with the exclusion of one of the values ​​ Use CountIF Except a Value • Use CountIF with the exclusion of one of the values ​​... Today function in Excel and its use to know the remaining days until a specific date • Today function in Excel and its use ... A simple explanation of dealing with large data and making a summary of it by using pivot tables Pivot Tables • Pivot Tables Explanation... Explanation of advanced filtering in Excel Advanced Filter • Advanced Filter in Excel Explanation of the tool... A simple way to select and delete empty rows How to delete the Empty Rows Excel Online • The fastest way to select and delete empty rows... Search with more than one condition in Excel tables Lookup with multiple Criteria in Excel Tables Excel Online • Use the vlookup function to search with more than one... Prevent duplication of values ​​within column cells Prevent Values ​​Duplication in Selected Column • Prevent duplication of data in Excel Exce... How to select different cells in a column and row Select the Different Cells In Columns and Rows • How to select different cells from the column... Editing more than one Excel Sheet At the same time - Apply Action on Multiple Sheets at the same time • Edit more than one Excel Sheet In... Practical explanation of how to design Infographic Charts On Excel - Excel Online • How to draw a chart Infographic Ch... Explanation of the tool for dividing cell contents in Excel Text to Column Practical explanation - Excel Online • Explanation of text to columns in Excel how t... Drop-down list tool Data Validation List Explanation of entering list data https://bit.ly/2WAj1Mj Trick to copy formulas between tables in Excel without any change Copy Formulas between Tables in Excel https://bit.ly/32Vu4SQ Function IF The compound and how to use it with the function OR - AND In Excel with practical explanation Excel Online https://bit.ly/2MHZLta Building dynamic drop-down lists using the function OFFSET and how to link more than one list https://bit.ly/31yZPPP Explanation of the function IF Error In Excel with its use to show more than one result - with practical explanation https://bit.ly/2MJaG4v Flash Fill The magic quick fill tool and how to use it to repeat the pattern of a cell - practical explanation https://bit.ly/2pcC42S Types of errors in Excel and how to solve them with a practical example for each error https://bit.ly/2MkvD5w A simple function that helps you create a random list in Excel Practical and simplified explanation https://bit.ly/2opGWB1 How to use the Max function with the If function to get the largest result with a condition https://bit.ly/2msxHjf NetworkDays NetworkDays.INTL A function to calculate the net number of working days between two dates, excluding holidays https://bit.ly/2mTQXWr A famous function in Excel that can be used to compare data between two columns!! With practical explanation https://bit.ly/2mueqxv Explanation of Circle Chart in Excel and how to write a Dynamic