Hi there, I am wanting a formula that can search through the row and when it finds the value ‘TRUE’ return the value 5 columns over. Example – true is in column AG and the cell I want it to return AB.

Is there a formula for this? 

Thank you. 

​Hi there, I am wanting a formula that can search through the row and when it finds the value ‘TRUE’ return the value 5 columns over. Example – true is in column AG and the cell I want it to return AB. Is there a formula for this?  Thank you.   Read More

​