Mar 09 2020 04:12 PM
For example IF ('!WORKSHEET!'D2=1, insert the contents of '!WORKSHEET!'D2
Mar 09 2020 10:37 PM
Hi @RED5HFT
You can use the formula as stated below
=IF(Sheet2!D2=1,Sheet2!D2,"")
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer.