Return Value based on 2 different cells Matching???

[aussie_fisher]

I am trying to return a value from column T by matching columns U & R. I.e. if a value in column U matches any number in column R, than return the number immediately to the left of matching column U.

Since U32 = a number in column in R, (in this case R33), I thought V32 should return -47.625, but I must be doing something wrong. (Image below).

I have limited experience with excel. I have used Index Match correctly in the past, but I feel there could be an easier way to find the correct value from T.

Please advise, how to FIX or EASIER WAY to do this. Many thanks in advance. (excel 2007)

 

[jasonb75]

Best guess would be that they are not an exact match. If the cells are formatted to 5 decimal places but the underlying values have higher precision then the formula will use the actual value, not the visible value.

 

[aussie_fisher]

Best guess would be that they are not an exact match. If the cells are formatted to 5 decimal places but the underlying values have higher precision then the formula will use the actual value, not the visible value.

Thank you, I have now applies a rounding function to all relevant figures so that isnt an issue anymore. However in the meantime,
I have created a work around using IF COUNTIF function which returns yes/no for matching numbers and then go from there.
Wish it was neater and I'm sure there's a better way but good enough for now... Thanks for your help!