• Skip to primary navigation
  • Skip to content
  • Skip to primary sidebar

GenronTech

Stay Connected with Technology

  • Home
  • Blog
  • Video Tutorial
    • All Video Tutorial
    • Software –
      • Advance Tally ERP Tutorials
      • Corel Draw Tutorials
      • Photoshop CC
    • E-Learning
    • Information Technology
    • Unboxing Gadgets
    • Gadgets Review & Specs
    • Online Money
    • Web Technology
    • Hardware
    • Android Play
    • Tech News
  • Online Important Links
    • Editing Tools
  • Quiz
    • Microsoft Ms Word
    • Microsoft Powerpoint
    • Microsoft Excel
    • Tally ERP 9
  • Download APK Files
Advanced Excel Formulas – DGET Function Description With Example

Advanced Excel Formulas – DGET Function Description With Example

December 2, 2015 by Suniel Leave a Comment


Advance Excel Formulas

How many boxes of a particular item do we have in stock?

Criteria Range Is C23:F24

DGET

DATABASE FORMULA – DGET Function

What Does It Do ?
This function examines a list of information and produces one result.
If more than one record matches the criteria the error #NUM is shown.
If no records match the criteria the error #VALUE is shown.

Syntax
=DGET(DatabaseRange,FieldName,CriteriaRange)

Description For DMIN Function

  • The DatabaseRange is the entire list of information you need to examine, including the field names at the top of the columns.
  • The FieldName is the name, or cell, of the values to Get, such as “Value Of Stock” or I3.
  • The CriteriaRange is made up of two types of information.
    The first set of information is the name, or names, of the Fields(s) to be used as the basis for selecting the records, such as the category Brand or Wattage.
    The second set of information is the actual record which needs to be selected, such  as Horizon as a brand name, or 100 as the wattage.

Formatting
No special formatting is needed.

GenronTech Header-Cartoon


Examples 1

This example extracts information from just one record.

How many boxes of a particular item do we have in stock?

DGETCriteria Range Is C51:F52

The number in stock is :  DCOUNTA_18 =DGET(B3:I19,H3,C51:F52)


Examples 2

This example extracts information from multiple records and therefore shows the #NUM error.

How many boxes of a particular item do we have in stock?

DGET_03Criteria Range Is C63:F64

The number in stock is : DGET_07 =DGET(B3:I19,H3,C63:F64)


Examples 3

This example extracts information from no records and therefore shows the #VALUE error.

How many boxes of a particular item do we have in stock?

DGETCriteria Range Is C64:F65

The number in stock is :  VALUE ERROR =DGET(B3:I19,H3,C64:F65)


Examples 4

This example uses the =IF() function to display a message when an error occurs.

How many boxes of a particular item do we have in stock?

DGETCriteria Range Is C85:F86

The number in stock is : VALUE ERROR =DGET(B3:I19,H3,C85:F86)

no Product=IF(ISERR(F88),CHOOSE(ERROR.TYPE(F88)/3,”No such product.”,”Duplicates products found.”),”One product found.”)

GenronTech Header-Cartoon

Advanced Excel Formulas Index

  1. Jump To Advance Excel Formulas Main Menu
  2. Jump To Database Function
  3. Jump To Date and Time Function
  4. Jump To Financial Function
  5. Jump To Informational Function
  6. Jump to Logical Function
  7. Jump To Math Function
  8. Jump to Statistical Function
  9. Jump To Engineering Function
  10. Jump To Text Function

If You Like The Articles then do share it on your Profile

  • Print
  • Tweet
  • Share on Tumblr
  • Email

Filed Under: Excel Formulas Tagged With: Database Formulas, Excel Formulas

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Social Links

  • View Genrontech’s profile on Facebook
  • Twitter
  • Instagram
  • Pinterest
  • LinkedIn
  • YouTube
  • Google+

Top Videos

subscribeSubscribe to Our Channel
«
Prev
1
/
2
Next
»
loading
play
Unboxing 1Mp Night Vision Dome Camera | 720p | Support All DVR | 20M IR Range | 25/30fps
play
Unboxing CP Plus Cosmic 4Ch DVR | CCTV Setup | What is DVR? | Setting | Price to Setup CCTV Camera
play
How to Install Hard Disk in DVR | Cp Plus | CCTV Setup
play
Connect BNC Connector to CCTV Cable and DC Connector At Home | 3+1 Copper Wire Cable | CCTV Setup
play
Material Required to Setup CCTV Surveillance Camera in Office or Home | Surveillance Camera Setup
play
CP Plus IP Camera Installation and Configuration in Hindi | CP Plus CCTV Camera Installation
play
CP Plus Mobile View Configuration! CP Plus Remote View Software! CP Plus Live Preview!
play
Cp Plus CCTV Recording Kaise Dekhe in Hindi | How to Check/Search DVR Recording
play
CP Plus Transfer DVR Recordings to USB! Backup DVR to Pen Drive! How to Backup Cp Plus DVR
play
How to Connect 3g 4g Dongle to CCTV DVR! - Connect Tata,JIo,BSNL,MTNL,Airtel,Reliance,MTS,Aircel
play
How to Erase CCTV Camera Data | How to Format CCTV Surveillance Camera DVR Hard Drive Safely
play
CP PLUS DVR Online Mobile Live View without Internet! CP Plus Remote View Without Internet
play
Cp Plus CCTV Camera Video and Image Setting for Better View | Brightness, Contrast & Saturation
play
CP Plus - How to Change CCTV Camera Name (CAM 1/Cam 2 to Front Office/Back Office)
play
How to Make Cp Plus DVR Online | Enable DVR status Online for Remote View on Mobile & Laptop
«
Prev
1
/
2
Next
»
loading

Top Post

  • Basic Accounting Concepts and Principles/Rules in Tally ERP 9
    Basic Accounting Concepts and Principles/Rules in Tally ERP 9
  • Top 10 Free Domain Name Registration Website
    Top 10 Free Domain Name Registration Website
  • List of Groups in Tally - Meaning - Tally ERP 9 Tutorial Notes
    List of Groups in Tally - Meaning - Tally ERP 9 Tutorial Notes
  • WhatsApp Free Download for Laptop (Windows 10/8/7/XP)
    WhatsApp Free Download for Laptop (Windows 10/8/7/XP)

Recent Posts

  • Photoshop Content Aware Move Tool, Red Eye Tool | Photoshop CC 2018 Tutorial Hindi
  • Smoothen Face Skin, Remove Pimples and Blemishes in Photoshop | Healing Brush Tool | Patch Tool
  • Best Canon & Nikon DSLR Camera Price in India with Model Under 50,000
  • Best Android Smartphone for Gaming and Camera 2017
  • Top 7 Bezel Less Smartphone You can Buy in India 2017
  • Top 7 Gaming Laptop Under 80,000 INR Budget
  • How to build a computer from scratch with Video Tutorial
  • Smart China Vs The World in Technology
  • How to start a successful youtube channel
  • How to earn money from youtube by uploading videos
The Content on this website is , DMCA.com Protection Status
  • About me
  • Contact us
  • Private Policy
  • Sitemap

Copyright © 2019 · Aspire Pro on Genesis Framework · WordPress · Log in

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.