Hello,
I am trying to use an IF statement that refers to another worksheet in a workbook.
Here is what it looks like:
=IF("ORDER!A24"="PV","='ORDER!B24'",0)
What I am trying to accomplish in the cell is this: If cell A24 in the ORDER worksheet is equal to PV, then I want the information from cell B24 in the ORDER worksheet to show up in the cell. If it is not equal to PV, then I want it to stay blank.
It is not working and I'm not sure why.
Any help would be greatly appreciated.
Thanks!!
I am trying to use an IF statement that refers to another worksheet in a workbook.
Here is what it looks like:
=IF("ORDER!A24"="PV","='ORDER!B24'",0)
What I am trying to accomplish in the cell is this: If cell A24 in the ORDER worksheet is equal to PV, then I want the information from cell B24 in the ORDER worksheet to show up in the cell. If it is not equal to PV, then I want it to stay blank.
It is not working and I'm not sure why.
Any help would be greatly appreciated.
Thanks!!