S smsimmons New Member Jun 14, 2016 #1 working on a sheet with a formula - =(IFERROR(VLOOKUP($B3,'July Schedule'!A$2:C$122,3,0), " ")) which returns "01/00/00" whenever the lookup table doesn't have a date in the cell. Attachments vlookup table.PNG 7.1 KB · Views: 11 return dates.PNG 3.4 KB · Views: 10
working on a sheet with a formula - =(IFERROR(VLOOKUP($B3,'July Schedule'!A$2:C$122,3,0), " ")) which returns "01/00/00" whenever the lookup table doesn't have a date in the cell.
B bosco_yip Excel Ninja Jun 14, 2016 #2 Try, =IFERROR(1/(1/(VLOOKUP($B3,'July Schedule'!A$2:C$122,3,0))),"") Regards Bosco
S smsimmons New Member Jun 14, 2016 #3 bosco_yip said: Try, =IFERROR(1/(1/(VLOOKUP($B3,'July Schedule'!A$2:C$122,3,0))),"") Regards Bosco Click to expand... I inputted that formula and returned value 42570...
bosco_yip said: Try, =IFERROR(1/(1/(VLOOKUP($B3,'July Schedule'!A$2:C$122,3,0))),"") Regards Bosco Click to expand... I inputted that formula and returned value 42570...
S smsimmons New Member Jun 14, 2016 #5 vletm said: If You don't want to see 'zero values' then apply next setting! View attachment 31780 Click to expand... That was the winner!! Smallest things are often overlooked. Thanks!
vletm said: If You don't want to see 'zero values' then apply next setting! View attachment 31780 Click to expand... That was the winner!! Smallest things are often overlooked. Thanks!
