{"id":193062,"date":"2023-03-24T12:28:01","date_gmt":"2023-03-24T12:28:01","guid":{"rendered":"https:\/\/datascientest.com\/?p=193062"},"modified":"2023-11-09T13:30:24","modified_gmt":"2023-11-09T13:30:24","slug":"fonction-recherchev-power-query","status":"publish","type":"post","link":"https:\/\/datascientest.com\/fonction-recherchev-power-query","title":{"rendered":"Fonction RECHERCHEV sur Power Query : Comment l&rsquo;utiliser ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"193062\" class=\"elementor elementor-193062\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3e9188a e-flex e-con-boxed e-con\" data-id=\"3e9188a\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-46e59cb elementor-widget elementor-widget-heading\" data-id=\"46e59cb\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Si RECHERCHEV est l\u2019une des formules les plus connues d\u2019Excel, elle peut aussi \u00eatre utilis\u00e9e dans Power Query. Mais dans ce cadre, la requ\u00eate pr\u00e9sente plusieurs sp\u00e9cificit\u00e9s. Alors comment utiliser la recherche V dans Power Query ? D\u00e9couvrez la r\u00e9ponse.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-4c72325 e-flex e-con-boxed e-con\" data-id=\"4c72325\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5de636b elementor-widget elementor-widget-heading\" data-id=\"5de636b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">\u00c0 quoi sert la fonction RECHERCHEV ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2f04805 elementor-widget elementor-widget-text-editor\" data-id=\"2f04805\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><span style=\"font-weight: 400;\">Comme son nom l\u2019indique, RECHERCHEV permet de <\/span><b>rechercher une donn\u00e9e au sein d\u2019une feuille de calcul.\u00a0<\/b><\/p><p><span style=\"font-weight: 400;\">L\u2019id\u00e9e est alors d\u2019associer les bonnes donn\u00e9es, m\u00eame s\u2019il y a plusieurs centaines de lignes.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Pour vous aider \u00e0 mieux comprendre, voici un exemple concret.<\/span><\/p><p><span style=\"font-weight: 400;\">Un magasin bio poss\u00e8de deux tableaux de donn\u00e9es :\u00a0\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Le premier tableau transmis par le fournisseur comprend l\u2019ensemble des produits livr\u00e9s, leurs caract\u00e9ristiques, leur quantit\u00e9, etc.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Le second tableau regroupe toutes les ventes r\u00e9alis\u00e9es, avec les quantit\u00e9s vendues, le nom des produits, leur r\u00e9f\u00e9rence\u2026\u00a0<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-07e1873 elementor-widget elementor-widget-text-editor\" data-id=\"07e1873\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">L\u2019objectif de ce magasin est de conna\u00eetre le stock disponible. Mais pour cela, il faut rapprocher les donn\u00e9es de ces deux tableaux. Plus pr\u00e9cis\u00e9ment, int\u00e9grer le nombre de ventes dans le premier tableau. C\u2019est \u00e0 cet instant qu\u2019intervient RECHERCHEV dans <a href=\"https:\/\/datascientest.com\/power-query-tout-savoir\">Power Query<\/a><\/span><span style=\"font-weight: 400;\">.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b5bf078 elementor-widget elementor-widget-image\" data-id=\"b5bf078\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1623\" height=\"716\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/power-query.jpg\" class=\"attachment-full size-full wp-image-193079\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/power-query.jpg 1623w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/power-query-300x132.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/power-query-1024x452.jpg 1024w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/power-query-768x339.jpg 768w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/power-query-1536x678.jpg 1536w\" sizes=\"(max-width: 1623px) 100vw, 1623px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-782c8b1 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"782c8b1\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-power-bi\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">D\u00e9couvrir la formation Power BI<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-36bd170 e-flex e-con-boxed e-con\" data-id=\"36bd170\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-56ef2f5 elementor-widget elementor-widget-heading\" data-id=\"56ef2f5\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Comment utiliser la fonction RECHERCHEV dans Power Query ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e0ece93 elementor-widget elementor-widget-text-editor\" data-id=\"e0ece93\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Traditionnellement, la RECHERCHEV sur Excel implique une formule assez simple. Mais avec Power Query, cette fonction est l\u00e9g\u00e8rement diff\u00e9rente. Il s\u2019agit alors de fusionner les requ\u00eates. Voici toutes les \u00e9tapes pour utiliser la recherche V dans Power Query.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-576b0d5 elementor-widget elementor-widget-heading\" data-id=\"576b0d5\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">La cr\u00e9ation et le nom des tableaux<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ba06ad3 elementor-widget elementor-widget-text-editor\" data-id=\"ba06ad3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Pour utiliser pleinement la RECHERCHEV dans Power Query, il est pr\u00e9f\u00e9rable que vos donn\u00e9es soient int\u00e9gr\u00e9es dans des tableaux. Cela vous permet ainsi de les <\/span><b>nommer pour identifier plus facilement les donn\u00e9es.\u00a0<\/b><\/p><p><span style=\"font-weight: 400;\">Si l\u2019on reprend l\u2019exemple mentionn\u00e9 pr\u00e9c\u00e9demment, vous pouvez nommer vos tableaux \u00ab\u00a0Produits\u00a0\u00bb et \u00ab\u00a0Vente\u00a0\u00bb.\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d724de9 elementor-widget elementor-widget-heading\" data-id=\"d724de9\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">L\u2019importation dans Power Query<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-69f00e2 elementor-widget elementor-widget-text-editor\" data-id=\"69f00e2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Une fois que vos tableaux sont pr\u00eats, vous pouvez les importer dans Power Query.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Pour cela, il suffit d\u2019aller dans l\u2019onglet \u00ab\u00a0Donn\u00e9es\u00a0\u00bb et de cliquer sur \u00ab\u00a0\u00e0 partir d\u2019un tableau ou d\u2019une plage\u00a0\u00bb. <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-582aa85 elementor-widget elementor-widget-heading\" data-id=\"582aa85\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">La connexion<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-56ecb7d elementor-widget elementor-widget-text-editor\" data-id=\"56ecb7d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Si vos donn\u00e9es sont d\u00e9j\u00e0 format\u00e9es dans le bon format, vous n\u2019avez pas besoin de les transformer dans Power Query. Nous vous conseillons alors de <\/span><b>ne conserver que la connexion aux donn\u00e9es<\/b><span style=\"font-weight: 400;\">. Pour cela, voici les \u00e9tapes \u00e0 suivre :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquer sur \u00ab\u00a0Fermer et charger\u00a0\u00bb<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquer sur \u00ab\u00a0Fermer et charger dans\u2026\u00a0\u00bb<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cocher l\u2019option \u00ab\u00a0Ne cr\u00e9er que la connexion\u00a0\u00bb. <\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c4cf0b6 elementor-widget elementor-widget-text-editor\" data-id=\"c4cf0b6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">L\u2019objectif de cette manipulation est d<\/span><b>\u2019\u00e9viter de charger des donn\u00e9es inutilement <\/b><span style=\"font-weight: 400;\">dans votre feuille de calcul.\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\"><strong>Bon \u00e0 savoir <\/strong>: si vos donn\u00e9es ne sont pas au bon format, il est pr\u00e9f\u00e9rable de les transformer en amont.\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-97db3db elementor-widget elementor-widget-heading\" data-id=\"97db3db\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">La fusion des tableaux<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0f80285 elementor-widget elementor-widget-text-editor\" data-id=\"0f80285\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Lorsque vos deux tableaux sont import\u00e9s dans Power Query, vous pouvez les fusionner.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Pour cela, vous devez vous rendre\u00a0 dans l&rsquo;onglet \u00ab\u00a0Accueil\u00a0\u00bb. Ensuite vous avez le choix entre deux options :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquer sur \u00ab\u00a0fusionner des requ\u00eates\u00a0\u00bb : si vous souhaitez ajouter l\u2019\u00e9tape de fusion aux requ\u00eates existantes.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquer sur \u00ab\u00a0fusionner des requ\u00eates comme nouvelle\u00a0\u00bb\u00a0 : si vous souhaitez cr\u00e9er une nouvelle requ\u00eate \u00e0 partir de la fusion.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-56f4cbf elementor-widget elementor-widget-text-editor\" data-id=\"56f4cbf\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">\u00c0 partir de l\u00e0, vous <\/span><b>choisissez les requ\u00eates \u00e0 fusionner. <\/b><span style=\"font-weight: 400;\">Pour reprendre notre exemple, il s\u2019agit du tableau Vente et du tableau Produit. Ces derniers doivent \u00eatre visibles depuis le menu d\u00e9roulant.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">C\u2019est justement pour cette raison qu\u2019il est primordial de nommer vos tableaux en amont.\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2a0ef29 elementor-widget elementor-widget-image\" data-id=\"2a0ef29\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"900\" height=\"500\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/fusion-requete-power-query.png\" class=\"attachment-full size-full wp-image-193080\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/fusion-requete-power-query.png 900w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/fusion-requete-power-query-300x167.png 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/fusion-requete-power-query-768x427.png 768w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2759c84 elementor-widget elementor-widget-heading\" data-id=\"2759c84\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">La s\u00e9lection des colonnes<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4bf16ea elementor-widget elementor-widget-text-editor\" data-id=\"4bf16ea\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Pour finaliser votre RECHERCHEV dans Power Query, vous devez <\/span><b>s\u00e9lectionner les colonnes \u00e0 fusionner<\/b><span style=\"font-weight: 400;\">. Il vous suffit de cliquer sur les colonnes communes aux deux tableaux.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Dans notre exemple, il s\u2019agit de la colonne produit.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Par ailleurs, Power Query vous permet de<\/span><b> r\u00e9aliser plusieurs recherches V en m\u00eame temps. <\/b><span style=\"font-weight: 400;\">C\u2019est-\u00e0-dire que vous pouvez fusionner plusieurs colonnes. Pour cela, vous devez s\u00e9lectionner une colonne et appuyer sur la touche Control. Cela permet alors de faire une multi-s\u00e9lection. Vous devez ensuite s\u00e9lectionner une autre colonne.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Par principe, l\u2019ordre de s\u00e9lection des colonnes appara\u00eet sur le tableau.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\"><strong>Bon \u00e0 savoir :<\/strong> il est possible que le nom de la colonne soit diff\u00e9rent selon les tableaux. Par exemple \u201cProduct\u201d et \u201cProduit\u201d. En revanche, toutes les donn\u00e9es doivent \u00eatre identiques. <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1af2450 elementor-widget elementor-widget-heading\" data-id=\"1af2450\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">La validation<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e4db2cb elementor-widget elementor-widget-text-editor\" data-id=\"e4db2cb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Une fois que vous avez s\u00e9lectionn\u00e9 vos tableaux et colonnes \u00e0 fusionner, il suffit de cliquer sur \u00ab\u00a0Valider\u00a0\u00bb.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">\u00c0 ce stade, vous verrez une nouvelle colonne appara\u00eetre sur votre premier tableau avec un bouton d&rsquo;expansion. Si vous cliquez dessus,<\/span><b> toutes les donn\u00e9es du deuxi\u00e8me tableau s\u2019ajouteront automatiquement.\u00a0<\/b><\/p><p><span style=\"font-weight: 400;\">Votre RECHERCHEV dans Power Query a bien fonctionn\u00e9.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-4aae212 e-flex e-con-boxed e-con\" data-id=\"4aae212\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c8ebe60 elementor-widget elementor-widget-heading\" data-id=\"c8ebe60\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Apprenez \u00e0 utiliser la RECHERCHEV dans Power Query<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c0e1540 elementor-widget elementor-widget-text-editor\" data-id=\"c0e1540\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">La RECHERCHEV dans Power Query figure parmi les fonctionnalit\u00e9s incontournables de l\u2019\u00e9diteur de requ\u00eate. Mais c\u2019est loin d\u2019\u00eatre la seule. Et pour cause, cet outil de pr\u00e9paration des donn\u00e9es vous propose plus de 300 fonctionnalit\u00e9s de transformation. Alors pour toutes les ma\u00eetriser, mieux vaut \u00eatre bien form\u00e9. <strong>C\u2019est justement possible en <\/strong><\/span><strong>rejoignant Datascientest. <\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cba2874 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"cba2874\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-excel\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">S'informer sur notre formation Excel <\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e47d342 e-flex e-con-boxed e-con\" data-id=\"e47d342\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d19d590 elementor-widget elementor-widget-html\" data-id=\"d19d590\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"\u00c0 quoi sert la fonction Recherche V ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Comme son nom l\u2019indique, la recherche V permet de rechercher une donn\u00e9e au sein d\u2019une feuille de calcul.  L\u2019id\u00e9e est alors d\u2019associer les bonnes donn\u00e9es, m\u00eame s\u2019il y a plusieurs centaines de lignes.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment utiliser la fonction Recherche V dans Power Query ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Traditionnellement, la recherche V sur Excel implique une formule assez simple. Mais avec Power Query, cette fonction est l\u00e9g\u00e8rement diff\u00e9rente. Il s\u2019agit alors de fusionner les requ\u00eates. Voici toutes les \u00e9tapes pour utiliser la recherche V dans Power Query.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Si RECHERCHEV est l\u2019une des formules les plus connues d\u2019Excel, elle peut aussi \u00eatre utilis\u00e9e dans Power Query. Mais dans ce cadre, la requ\u00eate pr\u00e9sente plusieurs sp\u00e9cificit\u00e9s. Alors comment utiliser la recherche V dans Power Query ? D\u00e9couvrez la r\u00e9ponse. \u00c0 quoi sert la fonction RECHERCHEV ? Comme son nom l\u2019indique, RECHERCHEV permet de rechercher [&hellip;]<\/p>\n","protected":false},"author":74,"featured_media":193072,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2493],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Fonction RECHERCHEV sur Power Query : Comment l&#039;utiliser ?<\/title>\n<meta name=\"description\" content=\"Si RECHERCHEV est l\u2019une des formules les plus connues d\u2019Excel, elle peut aussi \u00eatre utilis\u00e9e dans Power Query. D\u00e9couvrez comment l&#039;utiliser.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/fonction-recherchev-power-query\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction RECHERCHEV sur Power Query : Comment l&#039;utiliser ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/fonction-recherchev-power-query\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-24T12:28:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:30:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/recherchev-power-query.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Antoine Tardivon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Antoine Tardivon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/fonction-recherchev-power-query\",\"url\":\"https:\/\/datascientest.com\/fonction-recherchev-power-query\",\"name\":\"Fonction RECHERCHEV sur Power Query : Comment l'utiliser ?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-03-24T12:28:01+00:00\",\"dateModified\":\"2023-11-09T13:30:24+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\"},\"description\":\"Si RECHERCHEV est l\u2019une des formules les plus connues d\u2019Excel, elle peut aussi \u00eatre utilis\u00e9e dans Power Query. D\u00e9couvrez comment l'utiliser.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/fonction-recherchev-power-query\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\",\"name\":\"Antoine Tardivon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"caption\":\"Antoine Tardivon\"},\"description\":\"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/\",\"Business Intelligence\"],\"url\":\"https:\/\/datascientest.com\/author\/antoinetardivon\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Fonction RECHERCHEV sur Power Query : Comment l'utiliser ?","description":"Si RECHERCHEV est l\u2019une des formules les plus connues d\u2019Excel, elle peut aussi \u00eatre utilis\u00e9e dans Power Query. D\u00e9couvrez comment l'utiliser.","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:\/\/datascientest.com\/fonction-recherchev-power-query","og_locale":"fr_FR","og_type":"article","og_title":"Fonction RECHERCHEV sur Power Query : Comment l'utiliser ?","og_url":"https:\/\/datascientest.com\/fonction-recherchev-power-query","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-03-24T12:28:01+00:00","article_modified_time":"2023-11-09T13:30:24+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/recherchev-power-query.png","type":"image\/png"}],"author":"Antoine Tardivon","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Antoine Tardivon","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/fonction-recherchev-power-query","url":"https:\/\/datascientest.com\/fonction-recherchev-power-query","name":"Fonction RECHERCHEV sur Power Query : Comment l'utiliser ?","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-03-24T12:28:01+00:00","dateModified":"2023-11-09T13:30:24+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57"},"description":"Si RECHERCHEV est l\u2019une des formules les plus connues d\u2019Excel, elle peut aussi \u00eatre utilis\u00e9e dans Power Query. D\u00e9couvrez comment l'utiliser.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/fonction-recherchev-power-query"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57","name":"Antoine Tardivon","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","caption":"Antoine Tardivon"},"description":"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.","sameAs":["https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/","Business Intelligence"],"url":"https:\/\/datascientest.com\/author\/antoinetardivon"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/193062"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/74"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=193062"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/193062\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/193072"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=193062"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=193062"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=193062"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}