Having a slight issue that when using below formula to lookup and return a date from another sheet which is generated from a Query connection.
=IF(P4>0,VLOOKUP(A4,Near_Miss!A:H,3,FALSE))
Tried below to remove "FALSE"
=IFERROR(IF(P4>0,VLOOKUP(A4,Near_Miss!A:H,3,FALSE)),"")
Above is a If statement that anything above 0 would then use the lookup and return a date value into that cell.
if no date identified with above formula "FALSE" is generated in the cell and using the IFERROR doesn't remove this within that cell.
Bookmarks