I have a vlookup formula which is returning the correct data however it is displaying it as a # only in the cell.
When I hover over the # it is revealing the correct information but not displaying it as a value as a default.
Any suggestions as to how to correct this?
Any help very much appreciated.
