I am having trouble getting the following code to return a Blank when no date occurs in the two locations it looks
=IFERROR(VLOOKUP($A68,Sheet1!$F$1:$DC$2584,20,FALSE),VLOOKUP($A68,Sheet2!$F$1:$DC$2584,20,FALSE))
Currently if it find a matching number in $A68 on Sheet1 or Sheet2 it returns the Date from 20 over from $F$1 in my spread sheet. However when there is no date and it is blank, I receive 1/0/1900. I am using this sheet and date to fill another forums. Everytime I find a way to write the code to return a blank, I loose the ability to search in both Sheet1 and Sheet2.
Can someone help me out here.
Bookmarks