Forum Discussion

Taytoutay's avatar
Taytoutay
Copper Contributor
May 11, 2020
Solved

Excel VLOOKUP (RECHERCHEV) help

Hi, I don't know if there's french speaking people here so to be sure I'll write the question in both languages.  Bonjour, je ne sais pas s'il y a des français ici alors je mets la question en franç...
excel
Formulas and Functions
office 365
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    May 12, 2020

    Taytoutay Have a look at the attached file. Couldn't see that you first table  is also a structured table. It becomes a bit different then, but I could build the formula just by pointing at C2 and it automatically becomes [@AGE], which means "the value in this row in the column named AGE".

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
May 12, 2020

Taytoutay 

Why use INDIRECT? The formula below should work just fine, provided that the ages in the"Age" and "Categorie" sheets are of the same data types.

 

=RECHERCHEV(C2;Tableau5[#Tout];2;VRAI)

 

 

 

  • Taytoutay's avatar
    Taytoutay
    Copper Contributor
    May 12, 2020
    Hi, I used it because I tried it without, exactly the same formula you've given me but I got the same error. I thought using indirect might force the formula to take the table in the sheet I wanted.

    What do you mean by same type of data ?
    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      May 12, 2020

      Taytoutay By "data types" I mean that if the lookup value (i.e. C2) is a number, the first column in "Tableau5" must also contain numbers. The may look like numbers, but perhaps they are in fact texts. If so, VLOOKUP will return an error #NA!

       

      • Taytoutay's avatar
        Taytoutay
        Copper Contributor
        May 12, 2020

        Riny_van_Eekelen Thanks for your response, but after verification,  it seems like it already is a number in both cases. And the formula still sends me to "#REF". 😕 

         

        I'm joining the file. Could you check what's wrong please ? If you have time of course. 🙂 

         

        I just changed the table name by "cat". 

         

        Thanks for your help 

Resources