Forum Discussion
VLOOKUP
Hi, the vlookup function does not seem to work on my excel. I get a blanc error message. i can not see what I do wrong. Quid?
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
I found my error. I used "," instead of ";" in the argument. In the instructions on your website, you use " ,". Therefore the confusion. Regards
- Dear Hans,
Thanks for your clarification. This makes sense, like pounds, feet, inches, bushels, stones, and what have you. We are not yet in a unified metric world. Regards patricksmits That depends on your regional settings.
I you use point as decimal separator, as is usual in English-speaking countries, you should use comma to separate the arguments of a function,
If you use comma as decimal separator, as in many continental European countries, semicolon is the separator of function arguments.