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 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 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

how doing a drawing a day changed my life david litchfield tedxbedfordthink fast talk smart matt abrahams tedxmontavistahighschoolbody language the power is in the palm of your hands allan pease tedxmacquarieuniversityhow you can actually use the new excel byrow bycol functionshow to build dynamic interactive dashboard in excel with pivot tables charts tutorial episode 1calculate percentages the right way in excel change amount after increasetalking about time in english 30 time phrases everyday english expressionscreate this restaurant touchscreen point of sale pos application in excel today full downloadhow to create an inventory assembly bill of materials bom application in excel free downloadexcel dget function solves 2 of your vlookup problemsfinancial performance analytics dashboard with a products search bar using excel vid tutorial 1past modals could have may have might have must have should have would have grammarhow to calculate hours worked in excel shortseasily combine text numbers into one cell in excel no concatenate7 things you re doing wrong in excelnew searchable drop down lists in excel with zero effortfully automated attendance sheet in excelmg hs phev user review pakwheelsexcel 3d formulas explained includes a bonus excel hackfully automated data entry software in excel data entry user form data entry in excelhow to print in excel print page setup in excelhow to create barcode in excel barcode in excelhow to build modern interactive dashboard in excelexcel finance class 18 asset efficiency ratio and cash cycle in daysmicrosoft excel financial functionsexcel finance class 06 relative and absolute cell references in copied formulasexcel finance class 02 getting started with formulas functions formula inputs and cell referencesexcel finance class 104 expected return standard deviation for 1 stock estimating futureanalysing lists of data on excel essential excel for financial analyst accountants and auditorsexcel finance class 83 estimating cash flows for npv calculationfinancial planning forecasting spreadsheet modelingexcel finance class 62 preferred stock valuation as a perpetuityexcel finance class 14 financial statement ratio analysis 1 trick for ratio analysisexcel finance class 11 finance cash flow from accounting informationexcel finance class 89 sensitivity analysis for cash flow npv calculationsscenario analysis how to build scenarios in financial modelinghow to build a basic financial model in excelppp project finance model in excel overview part 2 of 3financial dashboard template in excel dynamic flexible and easy to useexcel finance class 17 leverage solvency ratios debt to equity equity multiplier morehow to transfer share price data from yahoo finance to ms excelexcel finance class 10 income statement non cash depreciation expense matching principalexcel finance class 52 bond discount or premium amortization tableexcel finance class 67 irregular dividend payments followed by constant growth stock valuationpaper trading with yahoo finance and microsoft excel3 statement financial model building from scratchfinance basics 12 perpetuity calculation in excelfinancial modeling excel shortcuts videofinance with excel options graphexcel finance class 65 calculate stock price at time t using dividend growth modelexcel finance class 33 full life retirement plan pv annuity fv annuity pv pmt functionsfinance basics 7 future value examples in excel how much something is worth in the futureexcel finance class 41 interest only loan scheduleexcel finance class 105 expected return standard deviation for portfolio estimating futureadvanced excel 2019 introduction to financial functions in excel microsoft excel tutorialyahoo finance exporting income statements to excelexcel finance class 81 xnpv function xirr function see algorithm that xnpv usesretrieving financial metrics from yahoo finance to excel with pythonfinance in excel 1 live stock quotes in microsoft excel msn moneycentral investor stock quotesexcel finance class 27 asset valuation using discounted cash flow analysis and pv function

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