Maybe an Index Match Solution??

[Bkisley]

I have the following problem....

Cell P9 on Sheet 1 will have a rate that comes from a matrix on Sheet 2
Sheet 2 matrix has descriptions of the operations from cell L5:L50
Sheet 2 has my years across row 4 cells O to Y
Sheet 2 has the rates inside the matrix - cells O5:Y50

What I need to happen is based on the rate in cell P9 on Sheet 1 I need to return the value (year) in row 4.
In other words, find the rate from cell P9 on sheet 1 within O5:Y50 on sheet 2 and return the year from sheet 2 row 4

PLEASE HELP ME!
THANK YOU IN ADVANCE!

 

[mole999]

you can paste a useable view of your data with XL2BB, to make it clearer

 

[jasonb75]

I'm seeing
=IFERROR(INDEX(Sheet2!$O$4:$Y$4,MATCH(P9,INDEX(Sheet2!$O$5:$Y$50,MATCH(Z9,Sheet2!$L$5:$L$50,0),0),0),"No Match")

Where Z9 contains a description to match up to L5:L50, this information was missing from your post.