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

Formulas and Functions

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