Copper Contributor

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?

4 Replies


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

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

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