Forum Discussion

Copper Contributor

Mar 09, 2020

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

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

MVP

Mar 10, 2020

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.