Forum Discussion
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? ...
Most probably it shall be used semicolon instead of comma
Thx - this was it 🙂
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...
- Not sure why the EXCEL help function gave me commas!!
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