Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

How to write a formula that can use data from multiple sheets?

Copper Contributor

I need a formula that goes something like this: If cell B2 on worksheet3 is "Name of worksheet1" then use cell K2 from worksheet1 to subtract cell J2 from worksheet3. But if cell B2 on worksheet3 is "Name of worksheet2" then use cell I2 from worksheet2 to subtract cell J2 from worksheet3

1 Reply

@Rashhour123 

=IF(B3="worksheet1",worksheet3!J2-worksheet1!K2,IF(B3="worksheet2",worksheet3!J2-worksheet2!I2,""))

You can try a nested IF formula.

worksheets.JPG