Finding the value of a cell above a cell that meets a condition in a column

[rufuxinix]

In an Excel column I need to find the value of a cell that is immediately above.
Example: If I have cell values that end in 5, I want to extract the value of the cell above them.

 

[Cubist]

What if 5 is in the first cell in the column?

 

[mumps]

What do you want to do with them after you "extract" them?

 

[rufuxinix]

What if 5 is in the first cell in the column?

Not sure Excel can handle that without coding?

I used
=IF(RIGHT(A2,1)=5,A1,"")
but it doesn't seem to work.
Maybe I m doing something wrong but can't figure it out.

 

[rufuxinix]

What do you want to do with them after you "extract" them?

I want to extract them into a new column

 

[Cubist]

Let me rephrase my question. I don't know the layout of your data. There are 2 cases.
Case 1 (col A below): Your first data entry is in A2, and that cell ends with "5". Do you want to return the header (one cell above)?
Case 2 (col B below): Your first data entry is in A1, and that cell ends with "5" but there's no cell above. What do you want to return?

Book2
	A	B
1	Header1	SomethingEndsWith5
2	SomethingEndsWith5
Sheet4

 

[rufuxinix]

Let me rephrase my question. I don't know the layout of your data. There are 2 cases.
Case 1 (col A below): Your first data entry is in A2, and that cell ends with "5". Do you want to return the header (one cell above)?
Case 2 (col B below): Your first data entry is in A1, and that cell ends with "5" but there's no cell above. What do you want to return?

Book2
	A	B
1	Header1	SomethingEndsWith5
2	SomethingEndsWith5
Sheet4

 

[rufuxinix]

If the first row meets the condition it should not return a result, it's an exception.
Thanks.

 

[jolivanes]

Re: but it doesn't seem to work.
Meaning what? What do you get as a result?

=IF(RIGHT(RC[-1], 1) = "5", R[-1]C[-1], "Nothing")

 

[rufuxinix]

Re: but it doesn't seem to work.
Meaning what? What do you get as a result?

=IF(RIGHT(RC[-1], 1) = "5", R[-1]C[-1], "Nothing")

I get no result at all. I think I might be doing something wrong.