VLOOKUP

Question

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?

hansvogelaar · Answer

patricksmits&nbsp;
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?

patricksmits · Answer

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

hansvogelaar · Answer

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.

patricksmits · Answer

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

Forum Discussion

VLOOKUP

Share

Resources