Index vs. Match

Today I learned about Index (return value based on R and C location)  and Match (return the number based on the value provided.)

Then, I came up with this useless formua

=INDEX(Ben!A1:I1000,MATCH(VLOOKUP(A11,Ben!A:I,9,FALSE),Ben!I1:I1000,0),9)


I was trying to retrieve the value from another sheet, but wanted to retain the format.  Apparently, I need to write a macro for that.  It would be my next little project here.