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.

 

[jolivanes]

Make your workbook available and someone will have a check on it.

 

[rufuxinix]

Finally got it right.
Contacted MS they halped repair the app but it was still not working, after that.
Changed commas to semi-colons, now it works.
=IF(RIGHT(RC[-1]; 1) = "5"; R[-1]C[-1]; "")

2
4
5	4
15	5
3
23
45	23
6
7
4
8
9
10
35	10
43
76
25	76

Thank you for your efforts, to all who helped with this, much appreciated.
Regards.

 

[Joe4]

Some regional settings use commas as argument separators in formulas, and others use semi-colons.
It is often assumed that the person posting the question knows which one applies to them and their system.

The weird thing is if you use the wrong one, you usually get errors instead of it returning unexpected results.

For example, if I enter your final version which uses commas and not semi-colons, I do not get any results. I get this error:

 

[jolivanes]

Good to see you've got it working.
Good luck.