Use the DGET Function

preview_player
Показать описание
This video covers how to use the DGET database function. This is a good look up function to use in place of VLOOKUP if you want to get around the limitation that VLOOKUP will not bring back data that is on the leftmost columns from where you are starting at.

Feel free to provide a comment or share it with a friend!
------------------------------------ #excel
#msexcel
#excel
#msexcelandtricks
#exceltutorial
#doughexcel #excel
#msexcel
#excel
#msexcelandtricks
#exceltutorial
#doughexcel

---------------------
Excel Training:

Excel Books:
#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-
  1. Doug H
  2. match
  3. tutorial
  4. vlookup
  5. msofficetrain101
  6. microsoft
Рекомендации по теме
Excel DGET Function 0:11:18

Excel DGET Function Solves 2 of Your VLOOKUP Problems

Try The DGET 0:12:29

Try The DGET Function Instead of INDEXMATCH & XLOOKUP

How to use 0:02:19

How to use DGET Function in Excel| #Dget| How to create search box in Microsoft Excel

How to use 0:04:11

How to use DGET Formula in Excel | DGET Formula in Excel | Excel DGET Function

Excel's DGET Function: 0:07:46

Excel's DGET Function: Dynamic Data Retrieval Made Easy!

Master Advanced Excel: 0:00:32

Master Advanced Excel: DGET Function Tutorial & Tips for Beginners

=DGET in Excel‼️ 0:00:32

=DGET in Excel‼️ #excel

How To Use 0:00:33

How To Use DGET Function In Excel | Excel Hacks Excel Pro Tips | Excel In Interview Question

How to use 0:06:05

How to use the Indirect and DGet functions to return images and data in Microsoft Excel

How to Use 0:10:30

How to Use DGet Function In Excel

How to use 0:01:56

How to use DGET function in Excel :Tutorial

Using the DGET 0:02:37

Using the DGET Function in Excel - Learn Excel Formulas - Excel Tutorials For Beginners

Use the DGET 0:05:00

Use the DGET Function

I Discovered Excel's 0:02:04

I Discovered Excel's SECRET DGET Function and It Changed Everything

Dget Function 0:01:19

Dget Function

How to use 0:05:55

How to use Excel 2021 DGET function and best uses

Mastering the DGET 0:00:53

Mastering the DGET Function in Excel - Data Retrieval Made Easy #excel #exceltutorial #mexcel

How to use 0:04:09

How to use DGET function in Excel

How To Use 0:01:07

How To Use Excel DGET Function Simplified To Replace VLOOKUP & XLOOKUP Function

Excel Trick: How 0:00:45

Excel Trick: How to use DGET function in Excel

DGET - Powerful 0:15:54

DGET - Powerful VLOOKUP, INDEX-MATCH Replacement - Google Sheets Tutorial

How To Use 0:02:07

How To Use Excel DGET Function Simplified For Data Analysis

How to use 0:01:52

How to use DGET Function in Excel | Excel Tips

How to use 0:03:19

How to use the DGET Function in Microsoft Excel? #Excel #DGET

Комментарии
Автор

great video presented in a fashion that is consumable, good job Doug H.

yanthos
Автор

Thanks well explained very useful tip/trick for the benefit of Excel regular users. Expecting some more tricks/tips from your kit.

gopalakrishnarao
Автор

hi thanks for the video have learnt a lot from your channel, can dget be passed as an array formula and can it reuturn mutiple elements matching the criteria

jdurvesh
Автор

your videos special and unique, thank you sir

rameshyelle
Автор

in this example, can we sum the total amount of 'Emma' with dget function

Abdalee
Автор

wow, another useful function again ^^
Thanks Doug H

aekmit
Автор

Fine, I want to check other quies in next line. Means how to drag for other inputs.

pkalamkhan
Автор

i have a question, how to use this function if the criteria is horizontal, not vertikal

muhammadhatimaziz