There are two sheets, A and B
The value of C7 in Sheet A needs to be the value of J5 in Sheet B
Then copy C29 in Sheet A to F5 in Sheet B
The value of C7 in Sheet A needs to be the value of J6 in Sheet B
Then copy C29 in Sheet A to F6 in Sheet B
Or put another way
Sheet B F5 equals Sheet A C29 when Sheet A C7 equals Sheet B J5
Sheet B F6 equals Sheet A C29 when Sheet A C7 equals Sheet B J6
Not sure how to write this at all.
Any guidance would be appreciated.
Welcome, @fatbluecherry!
I assume that you are relatively new to Calc, so let me give you some detailed advices.
You want a result in cell F5 and F6, so you need to write a formula in each of these cells. A formula always starts with the = sign.
The address of a cell of the current sheet is the letter of the column followed by the row number, like C5, D887, AX92738. When we refer to a cell from another sheet, we prefix the name with $‘Sheet Name’.
There is a condition: IF cell Sheet A C7 EQUALS Sheet B J5, THEN put the value of Sheet A C29 into F5 (ELSE we don’t know so I assume we leave the cell blank)
So we can type in Sheet B F5:
=IF($'Sheet A'.C7=J5,$'Sheet A'.C29,"")