Referencing a Column in Another Sheet

Jstaley11

I am having trouble referencing a Column in another sheet through an IF formula I am trying to do. 

My current formulas is =IF({Sheet 1 Range 1} = 1, {Sheet 2 Range 2}). 

The first Column I am referencing is a Checkbox Column, and I only want it to return the value in Range 2 unless Range 1 is Checked. Whenever I do this formula it gives me the INVALID OPERATION error. 

I know this formulas works because when I do the exact same formulas but just reference the Cell rather than the column it returns the correct value no problem. It's only when I select the Column as a whole does it return the INVALID OPERATION error. I plan on adding and removing rows in the original sheet that's why I need to it to reference the whole column and not just the individual cells. 

If anyone has encountered this problem and has a solution that would be great. 

Thank you

Paul Newcome

I'm having trouble following exactly what it is you are trying to accomplish. Are you able to provide some screenshots with sensitive data removed or replaced with "dummy data"?