|
Deleting dates and vlookup
I have a vlookup working between two workbooks, however one of the columns is a date format dd/mm. If i blank out a date in the first workbook it appears as 00-01 in the second workbook. Is there a way to have my data to look like a date but to make the cell in second workbook appear blank if its blanked out in the first workbook instead of showing 00-01? ------------------------:) -- Boethius1 ------------------------------------------------------------------------ Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497 View this thread: http://www.excelforum.com/showthread...hreadid=515938 |
Deleting dates and vlookup
=if(vlookup(...)="","",vlookup(...))
Boethius1 wrote: I have a vlookup working between two workbooks, however one of the columns is a date format dd/mm. If i blank out a date in the first workbook it appears as 00-01 in the second workbook. Is there a way to have my data to look like a date but to make the cell in second workbook appear blank if its blanked out in the first workbook instead of showing 00-01? ------------------------:) -- Boethius1 ------------------------------------------------------------------------ Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497 View this thread: http://www.excelforum.com/showthread...hreadid=515938 -- Dave Peterson |
| All times are GMT +1. The time now is 12:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com