excel dget function solves 2 of your vlookup problems

excel dget function is one of excel's "forgotten" database functions that can do a left lookup (unlike vlookup) and also easily look for multiple criteria.

★ my online excel courses ► https://www.xelplus.com/courses/

one limitation of dget is that you can't apply it to multiple cells. basically you can't pull down the formula to lookup different values. if that's something you need, then you'll need to use index match, vlookup, excel filter function or filter feature or xlookup. check out the links under related videos below to find these videos.

★ get the official xelplus merch: https://xelplus.creator-spring.com/

00:00 excel dget function
01:44 excel dget explained
06:03 dget with approximate match
06:28 dget with or & and conditions
08:18 dget with multiple criteria

dget can lookup values to the left and act like an automatic filter.

excel dget disadvantages:
1. dget formula can't be pulled down - you'll need to include the header for each lookup value
2. dget returns an error (#num error - 7:25) if there are duplicate lookup values in the range (as opposed to vlookup or index & match which return the first match).

⯆ download the workbook at the bottom of the blog post here: https://www.xelplus.com/excel-dget-function

------ related videos -------
excel index match basics: https://youtu.be/f264fpbdx28
excel vlookup explained: https://youtu.be/hwl6kkjp-_i
excel xlookup: https://youtu.be/4c0cluer6nw
excel filter function: https://youtu.be/eehk6pc0ogs
check out the complete excel lookup formula playlist: https://www.youtube.com/playlist?list=plmhvyfmcrkyxpmnh_kkfagp5df9ydawmi

★ my online excel courses ► https://www.xelplus.com/courses/

✉ subscribe & get my top 10 excel formulas e-book for free
https://www.xelplus.com/free-ebook/

excel resources i recommend: https://www.xelplus.com/resources/

gear i use: https://www.xelplus.com/resources/#gear

more resources on my amazon page: https://www.amazon.com/shop/leilagharani

let’s connect on social:
instagram: https://www.instagram.com/lgharani
twitter: https://twitter.com/leilagharani
linkedin: https://at.linkedin.com/in/leilagharani

note: this description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. this helps support the channel and allows us to continue to make videos like this. thank you for your support!

#msexcel

excel dget function solves 2 of your vlookup problems



excel dget function solves 2 of your vlookup problems excel dget function is one of excel's "forgotten" database functions that can do a left lookup (unlike vlookup) and also easily look for multiple criteria.★ my online excel courses ► https://www.xelplus.com/courses/one limitation of dget is that you can't apply it to multiple cells. basically you can't pull down the formula to lookup different values. if that's something you need, then you'll need to use index match, vlookup, excel filter function or filter feature or xlookup. check out the links under related videos below to find these videos.★ get the official xelplus merch: https://xelplus.creator-spring.com/00:00 excel dget function01:44 excel dget explained06:03 dget with approximate match06:28 dget with or & and conditions08:18 dget with multiple criteriadget can lookup values to the left and act like an automatic filter.excel dget disadvantages:1. dget formula can't be pulled down - you'll need to include the header for each lookup value2. dget returns an error (#num error - 7:25) if there are duplicate lookup values in the range (as opposed to vlookup or index & match which return the first match).⯆ download the workbook at the bottom of the blog post here: https://www.xelplus.com/excel-dget-function------ related videos -------excel index match basics: https://youtu.be/f264fpbdx28excel vlookup explained: https://youtu.be/hwl6kkjp-_iexcel xlookup: https://youtu.be/4c0cluer6nwexcel filter function: https://youtu.be/eehk6pc0ogscheck out the complete excel lookup formula playlist: https://www.youtube.com/playlist?list=plmhvyfmcrkyxpmnh_kkfagp5df9ydawmi ★ my online excel courses ► https://www.xelplus.com/courses/✉ subscribe & get my top 10 excel formulas e-book for freehttps://www.xelplus.com/free-ebook/excel resources i recommend: https://www.xelplus.com/resources/gear i use: https://www.xelplus.com/resources/#gearmore resources on my amazon page: https://www.amazon.com/shop/leilagharanilet’s connect on social:instagram: https://www.instagram.com/lgharanitwitter: https://twitter.com/leilagharanilinkedin: https://at.linkedin.com/in/leilagharaninote: this description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. this helps support the channel and allows us to continue to make videos like this. thank you for your support!#msexcel

اغاني من كلمات ناصر كدسه - اعمال ناصر كدسه الفنيه

3NONI -halogenware -hocketoanvn -zithromax365 -wneen -prozac -lasix365 -expertsmigration -kahtaguncel -ufabet-win -finance us amagazine -oaksheritagecentre -tonystark -themetoday -essay2y -scattyfox -alanrickmandaily -hibagsmart -lormaspring -online store tutorial -كلمات اغاني - عيادات رويال - عيادات رويال البيطرية للحيوانات الأليفة - عيادة بيطرية متنقلة - عيادة بيطرية متنقلة جدة - عيادة بيطرية جدة - المطربين - الشعراء - الملحنين - الموزعين - الالبومات - دليل السياحة