Cross sheet formula to pull in value
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.
Answers

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

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.

Your most recent description is the opposite of the original description. Give this a try:
=INDEX(COLLECT({Range 1}, {Range 2}, @cell> 0), 1)
Help Article Resources
Categories
Check out the Formula Handbook template!