Forum Discussion
liz123395
Jun 10, 2024Copper Contributor
If true then return value in another cell near it
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.
- djclementsBronze Contributor
liz123395 If I've understood you correctly, the following syntax will return the value 5 columns to the left of the matching column:
=INDEX(vector, MATCH(TRUE, vector, 0) - 5)
Substitute vector with the range of the row you are searching, e.g. A2:AZ2.