Apr 23 2020 04:25 AM
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
Apr 23 2020 04:29 AM
Apr 23 2020 04:31 AM
Apr 23 2020 04:47 AM
Apr 23 2020 05:01 AM
Apr 23 2020 05:44 AM
Apr 23 2020 05:54 AM
Hi
I copied it but still get the error message - I wanted to know what changes he made...
Apr 23 2020 05:54 AM
Most probably it shall be used semicolon instead of comma
Apr 23 2020 06:22 AM
Apr 23 2020 06:31 AM
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
Apr 23 2020 06:38 AM
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
Apr 23 2020 06:51 AM
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...