Forum Discussion

RED5HFT's avatar
RED5HFT
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

excel

1 Reply

  • ExcelExciting's avatar
    ExcelExciting
    MVP
    Mar 10, 2020

    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.

Resources