Forum Discussion

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?

=VLOOKUP('Environement de control'!G6, Aperçu!B17:C20,2,FALSE)

Thx

Formulas and Functions

14 Replies

Abiola1
MVP
Apr 23, 2020
If possible to attach the file, that will be fine to have better clarity
- MDV005
  Copper Contributor
  Apr 23, 2020
  Abiola1
  
  AS requested - formula is on second sheet G7
  Thx
  SCI - Evaluation et travail a faire.xlsx45 KB
  - Abiola1
    MVP
    Apr 23, 2020
    MDV005
    
    Fixed. See the attached solution.
    
    SCI - Evaluation et travail a faire.xlsx46 KB
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
  Copper Contributor
  Apr 23, 2020
  Sorry - this didn't seem to help
  - Patrick2788
    Silver Contributor
    Apr 23, 2020
    MDV005
    Were you looking to do more with the VLOOKUP? Abiola1 's solution looks good.