Oct 12 2022 11:28 AM
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
Oct 12 2022 12:12 PM
=IF(B3="worksheet1",worksheet3!J2-worksheet1!K2,IF(B3="worksheet2",worksheet3!J2-worksheet2!I2,""))
You can try a nested IF formula.