Hi all,
Im having trouble with looking up dates using vlookup function between tabs on the spreadsheet. It was returning #N/A and i read it was relating to the date/time so i created a INT column to round and changed formula to look up the column and now its just returning 0/01/1900.
Sorry if its a bit of blonde questing but im at a bit of a loss.
Cheers
Im having trouble with looking up dates using vlookup function between tabs on the spreadsheet. It was returning #N/A and i read it was relating to the date/time so i created a INT column to round and changed formula to look up the column and now its just returning 0/01/1900.
Sorry if its a bit of blonde questing but im at a bit of a loss.
Cheers
