I have cells linked between two different workbooks. I simply want to copy one cell to the other, however I would like when a cell in workbook A is blank then returns blank on workbook B instead of returning as 0. I believe you can use an IF function and possibly in conjunction with the EXACT function as well. I think I am close but the following returns as a #VALUE! error. Any help would be appriciated.

=IF('[Line List & Piping Isometric List.xlsx]List'!K8,(EXACT('[Line List & Piping Isometric List.xlsx]List'!K8,'[Line List & Piping Isometric List.xlsx]List'!K8)),"")