Double Lookups

Hello. I am currently having issues with my brain, and can't figure this out. I need a formula to detect a user selected item, and return a value based on another input item.

A B C D E F G H I J
1 Years 1 2 3 4 Years 1 2 3 4
2 1
3 2
4 3

Depending on the number of years the person has (input in A2), as well as their ranking (input by an X on the above sheet in B2:E2), it should return a value from the table F1:J4, based on where the user put an X in B2:E2. I am aware I can do IF statements, and create a bunch of hidden columns, but I am looking for a more elegant, thought out formula than I can create at the moment Thanks!

I hope this helps! Thank you!

http://www.excelforum.com/attachment...1&d=1304598334

OK, so in this example, the person has been here 2 years. They are ranked 2 out of 4. The resulting formula should be 5, based on I4. Thank you!