filter formula (two columns to the right)

[valmir]

Hello everyone
I have this formula:

=FILTER(R2:DO51;R2:DO2=24)

Problem is my result lies two columns to the right where the column with "24" is. In this (2 columns to the right) column there is no header that I can use as a reference. Any ideas?

 

[Phuoc]

Maybe like this:

=OFFSET(R2:R51,,MATCH(24,R2:DO2,0),,2)

 

[valmir]

Maybe like this:

=OFFSET(R2:R51,,MATCH(24,R2:DO2,0),,2)

thanks, and sorry for not being so clear. is it possible to have only the result of the second column, row 51?

 

[Phuoc]

Try change to:

=INDEX(R51:DO51,1,MATCH(24,R2:DO2,0)+2)

 

[valmir]

Try change to:

=INDEX(R51:DO51,1,MATCH(24,R2:DO2,0)+2)

Perfect! I can't thank you enough! God Bless!