Excel beginner - VLOOKUP

Copper Contributor

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

14 Replies
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)
If possible to attach the file, that will be fine to have better clarity

@Abiola1 

 

AS requested - formula is on second sheet G7

Thx

@MDV005 

 

Fixed. See the attached solution.

Abiola1_0-1587643249678.png

 

Sorry - this didn't seem to help

 

 

 

@Abiola1 

@MDV005 

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

Hi 

 

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

 

@Patrick2788 

@MDV005 

Most probably it shall be used semicolon instead of comma

Thx - this was it :)
Not sure why the EXCEL help function gave me commas!!

@MDV005 

My guess your main language for Excel is English, thus all help is also for English SKU. At the same your operation system locale is different. Assuming you are on Windows you may chcek

Win+R -> control international -> advanced

image.png

@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

 

 

@MDV005 

That'll do it. Years ago I was working with a client that reported IF was "broken" in his newly upgraded Office 2007.  He was quite upset with Excel.  Turns out he had been messing with the regional settings...