Using DGET - The Alternative of VLOOKUP, INDEX MATCH DGET Function Bangla
The DGET function can be helpful when using Excel for database management. The DGET function retrieves a value from a database list according to selection criteria.
where database is a range reference to the Excel table that holds the value you want to extract,
field tells Excel which column in the database to extract,
and criteria is a range reference that identifies the fields and values used to define your selection criteria.
Excel allows a user to get a single value from a database using the DGET function. This step by step tutorial will assist all levels of Excel users in getting a value from a database .
Learn how to match data, join data from different tables & worksheets using DGET function in Google Sheets. Learn differences between DGET, VLOOKUP, INDEX/MATCH and why DGET might be an interesting or sometimes better alternative to VLOOKUP & INDEX/MATCH.
DGET Syntax and Arguments
A function's syntax is the structure Excel uses to execute your request.
The syntax and arguments for the DGET function are:
All database functions have the same three arguments:
Database (required): Specifies the range of cell references containing the database. The field names must be included in the range.
Field (required): Indicates which column or field is to be used by the function in its calculations. Enter the argument either by typing the field name or the column number.
Criteria (required): Lists the range of cells containing the specified conditions. The range must include at least one field name from the database and at least one other cell reference indicating the condition to be evaluated by the function.
I think you have enjoyed this video.
If this tutorial really helps you, please like, comment, subscribe and share with your close friends. This is #ms_excel #bangla #tutorial #mamun_academy
............................................................................
..............Subscribe to Get More Videos...........
https://www.youtube.com/c/MaMuNAcadem...
............................................................................
..................................................................................................
Most Favorite Videos
আমার ভিডিও /টিউটোরিয়াল কোথা থেকে শুরু করবেন ?
• How My Tutorial Arranged_About MamuN Acad...
MS Excel Bangla Tutorial Playlist :
Excel Super Secret Tips & Tricks: https://goo.gl/5qSphJ
Mastery of If Function Bangla: https://goo.gl/jY76m4
MS Excel Essential Course : https://goo.gl/7EX1hk
MS Excel Intermediate Course: https://goo.gl/iatnNz
MS Excel Advanced Course: https://goo.gl/WFrvzU
MS Excel Formulas & Functions: https://goo.gl/7Da7oZ
MS Excel Pivot Table Magic: https://goo.gl/NGp13W
MS Word Essential Course: https://goo.gl/SVXefG
Magic of Conditional Formatting Bangla : https://goo.gl/j4N3sH
Mastery of VLOOKUP Function : https://goo.gl/1YAZ5y
Result Sheet Making Bangla : https://goo.gl/VnuZk6
Salary Sheet Making Hidden Tricks : https://goo.gl/KXsfyh
Master of Pivot Table : https://goo.gl/PaGUzj
MS Word Magic and Tips and Tricks : https://goo.gl/6b25kB
MS PowerPoint 2019 Bangla: https://goo.gl/eoeeMm
..................................................................................................
.................Social Media.................
Twitter : / cumamun
Google+ : https://plus.google.com/mamunacademy
LinkedIn : / abdulla-al-mamun-172629b4
Instagram: / al-mamun36
..............................................
........................................................
Music Credit goes to: "Royalty Free Music from Bensound" & http://www.bensound.com
Intro/Outro/Banner Creator:
Official™ ► http://bit.ly/OffTMDesigns
Glitchy FREE 2D Intro Template | After Effects Free Intro Template
.........................................................
Stay Tuned with Mamun Academy to get more Videos with Tips and Tricks. .
.................................................................................................
.................Social Media.................
Facebook Page : / mamunacademy4u
Facebook Group : / mamunacademy
Google+ : https://plus.google.com/mamunacademy
LinkedIn : / abdulla-al-mamun-172629b4
..............................................
........................................................
Music Credit goes to: "Royalty Free Music from Bensound" & http://www.bensound.com
Intro/Outro/Banner Creator:
Official™ ► http://bit.ly/OffTMDesigns
Glitchy FREE 2D Intro Template | After Effects Free Intro Template
.........................................................
Stay Tuned with Mamun Academy to get more Videos with Tips and Tricks.