In EXCEL can I use the IF statment to return the contects of a cell from another worksheet?

Copper Contributor

For example IF ('!WORKSHEET!'D2=1, insert the contents of '!WORKSHEET!'D2

1 Reply

Hi @RED5HFT 

 

You can use the formula as stated below 

 

=IF(Sheet2!D2=1,Sheet2!D2,"")

 

Snag_12f092.png

 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.