{"id":6503,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/bdlire\/"},"modified":"2021-02-26T08:04:56","modified_gmt":"2021-02-26T08:04:56","slug":"dget","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/dget\/","title":{"rendered":"BDLIRE"},"content":{"rendered":"

Description et exemple d’utilisation de la fonction DGET (BDLIRE)<\/h2>\n

La fonction DGET, ou BDLIRE dans les versions francophones de Microsoft Excel, est une fonction de base de donn\u00e9es essentielle pour extraire une valeur unique \u00e0 partir d’un tableau ou d’une plage qui r\u00e9pond \u00e0 des crit\u00e8res sp\u00e9cifiques. Elle est extr\u00eamement utile pour retrouver des informations pr\u00e9cises au sein d’un vaste ensemble de donn\u00e9es.<\/p>\n

 Syntaxe Excel: BDLIRE(base_de_donn\u00e9es; champ; crit\u00e8res)<\/code> Syntaxe Google Sheets: DGET(base_de_donn\u00e9es; champ; crit\u00e8res)<\/code> <\/pre>\n
    \n
  • base_de_donn\u00e9es<\/strong>: La plage de cellules constituant votre base de donn\u00e9es.<\/li>\n
  • champ<\/strong>: Le nom ou l’indice num\u00e9rique de la colonne de la plage de donn\u00e9es depuis laquelle la valeur doit \u00eatre extraite.<\/li>\n
  • crit\u00e8res<\/strong>: La plage de cellules contenant les crit\u00e8res d\u00e9finissant quelles lignes s\u00e9lectionner.<\/li>\n<\/ul>\n
    Exemple en Excel : Imaginez un tableau de donn\u00e9es d’employ\u00e9s avec des colonnes pour l’ID, le Nom, l’\u00c2ge, et le D\u00e9partement. Vous souhaitez conna\u00eetre l’\u00e2ge de l’employ\u00e9 avec l’ID 453.<\/p>\n\n\n\n\n\n
    ID<\/td>\nNom<\/td>\n\u00c2ge<\/td>\nD\u00e9partement<\/td>\n<\/tr>\n
    451<\/td>\nMoreau<\/td>\n29<\/td>\nRH<\/td>\n<\/tr>\n
    453<\/td>\nDupont<\/td>\n34<\/td>\nIT<\/td>\n<\/tr>\n
    454<\/td>\nDurand<\/td>\n22<\/td>\nMarketing<\/td>\n<\/tr>\n<\/table>\n
     BDLIRE(A1:D4; \"\u00c2ge\"; A7:B8)<\/code> <\/pre>\n
    Dans ce cas, A7:B8 contient :<\/p>\n\n\n
    ID<\/td>\n453<\/td>\n<\/tr>\n<\/table>\n
    Sc\u00e9narios pratiques d’utilisation<\/h2>\n
    DGET (BDLIRE) se pr\u00eate bien \u00e0 diff\u00e9rentes situations, notamment :<\/p>\n
    Extraction de donn\u00e9es sp\u00e9cifiques dans un contexte d’entreprise<\/h2>\n
    Dans un contexte professionnel o\u00f9 il est n\u00e9cessaire de consulter r\u00e9guli\u00e8rement des informations d\u00e9taill\u00e9es sur les employ\u00e9s, la fonction BDLIRE permet d’acc\u00e9der \u00e0 ces donn\u00e9es rapidement et avec pr\u00e9cision, \u00e9pargnant l’usage de filtrages manuels ou de recherches exhaustives.<\/p>\n
     BDLIRE(A1:D100, \"D\u00e9partement\", F1:G2)<\/code> <\/pre>\n
    O\u00f9 F1:G2 repr\u00e9sente la plage de crit\u00e8res, qui pourrait \u00eatre :<\/p>\n\n\n
    Nom<\/td>\nDupont<\/td>\n<\/tr>\n<\/table>\n
    Gestion des inventaires<\/h2>\n
    Dans la gestion des stocks, l’utilisation de DGET aide \u00e0 obtenir rapidement des d\u00e9tails pr\u00e9cis sur un produit gr\u00e2ce \u00e0 son identifiant unique au sein d’une grande base de donn\u00e9es d’inventaire. Cette fonction facilite et optimise le suivi des articles en stock.<\/p>\n
     BDLIRE(A1:E50, \"Quantit\u00e9 en stock\", H1:I2)<\/code> <\/pre>\n
    La plage H1:I2 pourrait comporter le crit\u00e8re suivant :<\/p>\n\n\n
    Produit ID<\/td>\n2003<\/td>\n<\/tr>\n<\/table>\n","protected":false},"excerpt":{"rendered":"
    Extrait d\u2019unE basE dE donn\u00e9Es un EnrEgistrEmEnt uniquE r\u00e9pondant aux crit\u00e8rEs sp\u00e9cifi\u00e9s<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[322],"tags":[],"class_list":["post-6503","post","type-post","status-publish","format-standard","hentry","category-base-de-donnees"],"acf":[],"yoast_head":"\nFonction DGET (BDLIRE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction DGET (BDLIRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/fr\/dget\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction DGET (BDLIRE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction DGET (BDLIRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/dget\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:04:56+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction DGET (BDLIRE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/dget\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/dget\/\",\"name\":\"Fonction DGET (BDLIRE) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:04:56+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction DGET (BDLIRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/dget\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/dget\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/dget\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Base de donn\u00e9es\",\"item\":\"https:\/\/functiontranslator.com\/fr\/base-de-donnees\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"BDLIRE\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction DGET (BDLIRE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction DGET (BDLIRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/fr\/dget\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction DGET (BDLIRE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction DGET (BDLIRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/dget\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:04:56+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction DGET (BDLIRE) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/dget\/","url":"https:\/\/functiontranslator.com\/fr\/dget\/","name":"Fonction DGET (BDLIRE) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:04:56+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction DGET (BDLIRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/dget\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/dget\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/dget\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Base de donn\u00e9es","item":"https:\/\/functiontranslator.com\/fr\/base-de-donnees\/"},{"@type":"ListItem","position":3,"name":"BDLIRE"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6503","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6503"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6503\/revisions"}],"predecessor-version":[{"id":29515,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6503\/revisions\/29515"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6503"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6503"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6503"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}