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".

     

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 

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      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".

       

      • Taytoutay's avatar
        Taytoutay
        Copper Contributor
        May 12, 2020
        You solved it thanks ! I didn't know about the @AGE thing, you learn me something ! Thanks a lot ! 😄

Resources