The formula below that is in W247 works correctly. You will notice if the lookup finds a value (the secondary VLOOKUP logis), that the formula returns the value in column 9.
But if the value for column 9 is blank, then I want blank returned.
Currently Excel is populating the value of "1/0/00"
I...