Hi,
When i vlookup a date, and if the cell has nothing in it, it = 00/01/1900, but i just want it to stay blank, if the vlookup = blanks.
How can i do the above please.
thank you in advance.
Hi,
When i vlookup a date, and if the cell has nothing in it, it = 00/01/1900, but i just want it to stay blank, if the vlookup = blanks.
How can i do the above please.
thank you in advance.
Perhaps something along these lines...
=IF(A1="","",VLOOKUP(A1,YourRange,2,0))
Is that something you can work with?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks