hi edward_glyver,
see i have just put the formulla in cell d9 =INDEX(INDIRECT("a1:a9",TRUE),MATCH(C2,A1:A9,0))
keeping the cell a1:a9 fill with some number, and it is working fine.