# Excel beginner - VLOOKUP

Highlighted
Occasional Contributor

# 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

14 Replies
Highlighted

# Re: Excel beginner - VLOOKUP

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)
Highlighted

# Re: Excel beginner - VLOOKUP

If possible to attach the file, that will be fine to have better clarity
Highlighted

# Re: Excel beginner - VLOOKUP

AS requested - formula is on second sheet G7

Thx

Highlighted

# Re: Excel beginner - VLOOKUP

Fixed. See the attached solution.

Highlighted

# Re: Excel beginner - VLOOKUP

Sorry - this didn't seem to help
Highlighted

Highlighted

# Re: Excel beginner - VLOOKUP

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

Highlighted

# Re: Excel beginner - VLOOKUP

Hi

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

Highlighted

# Re: Excel beginner - VLOOKUP

Most probably it shall be used semicolon instead of comma

Highlighted

# Re: Excel beginner - VLOOKUP

Thx - this was it
Highlighted

# Re: Excel beginner - VLOOKUP

Not sure why the EXCEL help function gave me commas!!
Highlighted

# Re: Excel beginner - VLOOKUP

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

Highlighted

# Re: Excel beginner - VLOOKUP

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

Highlighted

# Re: Excel beginner - VLOOKUP

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