=IF(ISNA(VLOOKUP(E4,'WIP_A.xlsm'!TaskRange,3,FALSE))," ",VLOOKUP(E4,'WIP_A.xlsm'!TaskRange,3,FALSE))&" "&IF(ISNA(VLOOKUP(E4,'WIP_A.xlsm'!TaskRange,6,FALSE))," ",VLOOKUP(E4,'WIP_A.xlsm'!TaskRange,6,FALSE))&"
"&IF(ISNA(VLOOKUP(E4,'WIP_A.xlsm'!TaskRange,9,FALSE))," ",VLOOKUP(E4,'WIP_A.xlsm'!TaskRange,9,FALSE))&" "&IF(ISNA(VLOOKUP(E4,'WIP_A.xlsm'!TaskRange,5,FALSE))," ",VLOOKUP(E4,'WIP_A.xlsm'!TaskRange,5,FALSE))&"
"&IF(ISNA(VLOOKUP(E4,'WIP_A.xlsm'!TaskRange,7,FALSE))," ",VLOOKUP(E4,'WIP_A.xlsm'!TaskRange,7,FALSE))&" "&IF(ISNA(VLOOKUP(E4,'WIP_A.xlsm'!TaskRange,8,FALSE))," ",VLOOKUP(E4,'WIP_A.xlsm'!TaskRange,8,FALSE))

Seems to me there should be a smarter way to implement this. Please advise. I have one list of data, but need to extract multiple cells to populate a calendar cell.

thanks you

heads up