I have made thousend of VLOOKUPs but suddenly I am facing an issus with this. I have tried formatting everything into but text and general, but no matter what I do it does not work.
Example:
Hi,
I compared excel settings and options and found that the decimal seperator has set to semi-colon. When changing to comma - everything worked fine again.
