VLOOKUP

[patricksmits]

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?

[#2]

@patricksmits 

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?

[#3]

I found my error. I used "," instead of ";" in the argument. In the instructions on your website, you use " ,". Therefore the confusion. Regards

[#4]

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

[#5]

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