Cross sheet formula to pull in value

Bwoods113

I am trying to write a formula that looks at another sheet, looks at 1 column if the column is NOT equal to 0 then it would pull in a different column's cell information.

=IF(INDEX({Job Intake Form - Fence Range 1},1){Job Intake Form - Fence Range 2}>0)

This is what I was thinking {Job Intake Form - Fence Range 1} references the column that I want the information to copy to my sheet, and {Job Intake Form - Fence Range 2} looks at the column to evaluate if it is greater than 0. Am I on the right track here? Any help is greatly appreciated.

Paul Newcome

So you want to bring in from Range 2 if Range 1 is not equal to zero?

Bwoods113

@Paul Newcome

I want to bring in the information from range 1 if the information in range 2 is not equal to 0. Do I have my formula set up backwards?

Thank you for your help.

Paul Newcome

Your most recent description is the opposite of the original description. Give this a try:

=INDEX(COLLECT({Range 1}, {Range 2}, @cell> 0), 1)