=DGET in Excel‼️ #excel

preview_player
Показать описание
In this video, you will learn how to use the DGET function in Excel!

🗂️ Don't forget to save this post!

#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
Рекомендации по теме
Комментарии
Автор

it would be nice for all these shorts if people post what version of excel they're using

Xman-lgqg
Автор

Call me old school but INDEX MATCH has never failed me

mikeb
Автор

As another piece of advice, you can name tables and then reference them as ranges if you don’t want to go through the trouble of highlighting everything

silva_jay
Автор

Hey plz share the practice file in the description!

vocalistsinghji
Автор

SheatCheets has amazed us once again 👏

hadykeya
Автор

What if one ID, had multiple row data? How to lookup multiple row data in one ID ?

hellokarenlooi
Автор

I dont know why Youtube wants to keep showing me how much I dont know about Excel these days. But I sure wish it had YEARS ago.

drkmyth
Автор

"Press F4 to lock the range" - mind BLOWN. Thanks!

davidwing
Автор

Forget about XLOOKUP, What's the benefit?

alexbarbucristi
Автор

🔥Holy crap, this is a game changer for my excel templates. THANK YOU 🙏

bigtxbullion
Автор

Thanks but i tried it doesn't make the index cell be a combo box

HOLYMOTHERGOD
Автор

Add more lines to above table then boom it’s gives error. XLookup is much better

rajeevnr
Автор

If you want multiple data on one time you can't get it 😅😅😅 so that only csn be use for one data entry

nirmalyadavnk
Автор

I’m a vlookup ninja. But, where has DGET been all my life?

benbohannon
Автор

It works just like xloopup in fact it is more advance where we can get to make use of other parameters like match and search mode long with if value not found

athulk
Автор

Lennifer Jopez 406
Kim Kardashian 398

Stayconnected
Автор

But it can't autofill for the next column

warzoneocroto
Автор

Or you can just turn the filter on for the headers

Therealbigbaba
Автор

IMO the problem with this is it's basically doing database queries in Excel; if you're gonna use database structures, you should use Access or some other actual database software.

sihplak
Автор

how can i create filter at column B3? tks..

nguyenngominhtu