hi

I'm trying to create an if statement that allows me to bring across data
from another worksheet within the same book.

However, when i create the 'true' statement and try to add the cell
reference from the previous worksheet the statement takes the worksheet &
cell name as the answer... so

so when in worksheet 2
=IF("worksheetA'!L3="Yes","'WorksheetA'!C3'","0")

then the 'True' answer goes into the cell as

'WorksheetA!C3'
Whereas i actually want what the 'text' is in the cell in that worksheet as
the answer.

are you able to have a cell as an answer to an 'IF' statement or will that
just not work?

Hope that makes sense....