Using Vlookup to return insted of 00/01/1900
Solved/Closed
Hello,
I am using a Vlookup to return values within a sheet using cell A2 as my reference some of the data that I am returning via the lookup are dates this is ok when there is a date value in the cell that I am returning but when the returning cell is blank it is returning a default date of 00/01/1900 how can I get to show a blank instead of 00/01/1900
I am using a Vlookup to return values within a sheet using cell A2 as my reference some of the data that I am returning via the lookup are dates this is ok when there is a date value in the cell that I am returning but when the returning cell is blank it is returning a default date of 00/01/1900 how can I get to show a blank instead of 00/01/1900
Related:
- Poppy playtime chapter 2 apk download
- Poppy playtime chapter 2 download apk - Best answers
- Poppy playtime chapter 0 apk download - Best answers
- Thunderbird return receipt - Guide
- Display two columns in data validation list but return only one - Guide
- Canon f17 1900 printer driver download - Download - Drivers
- Zuma return - Download - Puzzle
- Nokia.mobi/entry/van/main/c7-00 - Nokia Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 23, 2013 at 10:36 PM
Feb 23, 2013 at 10:36 PM
I think you need to use combination of iF and VLOOKUP,
like
=IF(vlookup(..)="","",Vlookup(..))
other way might be use a custom formula
like
=IF(vlookup(..)="","",Vlookup(..))
other way might be use a custom formula
