return cell value from another sheet

db0617

Hi, I would like to return cell values from another sheet if certain conditions are met:

if a box is ticked in Sheet A, the value of another cell in Sheet A shall appear in a cell in Sheet B, but if the box is not ticked, a complex IF-Formula shall be used in the cell in Sheet B.

Is this possible?

Denden8706

IN THE SHEET "B" CELL

=IF(REFERENCE ANOTHER SHEET[CHECK BOX]@ROW=1, REFERENCE ANOTHER SHEET[REFERENCE CELL]@ROW, "complex IF-Formula")