Forum Discussion

MDV005's avatar
MDV005
Copper Contributor
Apr 23, 2020

Excel beginner - VLOOKUP

Hi, Can anyone see what is wrong with this formula which requires the value in G6, to be search in the previous sheet  Cells B17-B20 and bring across the cell contents in the next column C17-C20?   ...
Formulas and Functions
Abiola1's avatar
Abiola1
MVP
Apr 23, 2020
Based the VLOOKUP formula
=VLOOKUP('Environement de control'!G6, Aperçu!B17:C20,2,FALSE)

There is need to apply Absolute Cell Reference to the Table Array second argument such as: =VLOOKUP('Environement de control'!G6, Aperçu!$B$17:$C$20,2,FALSE)
MDV005's avatar
MDV005
Copper Contributor
Apr 23, 2020
Sorry - this didn't seem to help
  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Apr 23, 2020

    MDV005 

    Were you looking to do more with the VLOOKUP? Abiola1 's solution looks good.

    • MDV005's avatar
      MDV005
      Copper Contributor
      Apr 23, 2020

      Hi 

       

      I copied it but still get the error message - I wanted to know what changes he made...

       

      Patrick2788 

      • Abiola1's avatar
        Abiola1
        MVP
        Apr 23, 2020

        MDV005 

         

        Hello, what I did is to apply Absolute Cell Reference to the table_array second argument and copy down the formula. See the attached file

         

        I guess your function separator is semi colon (;)... Over here in English, it is comma

         

         

Resources