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

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