If Statement with linked worksheets

[samira]

Hi! I am trying to write an If statement by linking 2 worksheets. This is the formula that I am trying to use =IF(G6=Sheet1!C2,Sheet4!P12,IF(OR(G6=Sheet1!C4,Sheet5!P14),))

The funny thing is that it is working for the first part but not for the second part.

Note : Cell G6 gets updated based on macro, so it picks up value from sheet1. So G6 can change and I want to write an IF statement so that when G6 changes value should get updated in the other cell.

Is this doable or is their any other solution?
Please help. Thanks

 

[Joe4]

Welcome to the Board!

The end of your formula seems to be missing some arguments:
=IF(G6=Sheet1!C2,Sheet4!P12,IF(OR(G6=Sheet1!C4,Sheet5!P14),))
The second IF statements checks for two conditions, but does nothing with the results, True or False.

Are there some typos?
Did it get chopped off?
What is it supposed to do?

 

[samira]

Hi, The second If statement should return the excate value from the cell P14 in the other sheet.
Thanks!

 

[Joe4]

Can you explain, in plan English, exactly how you would like the formula to work, including what to return if none of your conditions are met?