Hi all,
Really struggling with this one.
I am carrying out a vlookup against cells containing a date. I have established a way to do this to avoid returning #N/A for errors, but this then returns 00/01/1900 for cells containing no data. If I adjust the formula to get rid of the 00/01/1900 then the #N/A appear again!!
The formula I have for removing the #N/A is =IFERROR(VLOOKUP([@[PO Number]],Prev_Report,9,0),"")
The formula I have for removing the 00/01/1900 is =IF(VLOOKUP([@[PO Number]],Prev_Report,9,0)=0,"",VLOOKUP([@[PO Number]],Prev_Report,9,0))
Is there a way of combining these in some way to avoid both?
I only want it to return a result if there is a date in the resulting cell
Really struggling with this one.
I am carrying out a vlookup against cells containing a date. I have established a way to do this to avoid returning #N/A for errors, but this then returns 00/01/1900 for cells containing no data. If I adjust the formula to get rid of the 00/01/1900 then the #N/A appear again!!
The formula I have for removing the #N/A is =IFERROR(VLOOKUP([@[PO Number]],Prev_Report,9,0),"")
The formula I have for removing the 00/01/1900 is =IF(VLOOKUP([@[PO Number]],Prev_Report,9,0)=0,"",VLOOKUP([@[PO Number]],Prev_Report,9,0))
Is there a way of combining these in some way to avoid both?
I only want it to return a result if there is a date in the resulting cell