I am using a Vlookup function to find dollar values, dates, and names of
vendors made within a department.
The dollar values are appearing correctly, but the dates appears as
"01/00/00" when the field is empty and all the text strings appear as "0"
even though there is a name in the source sheet.
I have changed the formatting of each cell to be correct to the appropriate
format (accountancy, date, text) and even tried 'general' to fix this text
problem to no avail.
HELP!!