Forum Discussion

liz123395's avatar
liz123395
Copper Contributor
Jun 10, 2024

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. 

  • djclements's avatar
    djclements
    Bronze 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.

Resources