Hello, I've works with excel for a lot of things and this is just a side project for me. I'm having trouble getting it to work and I would like to ask you guys to help me if you guys have time to spare. Since I don't know how to do Macro or VBA, I'm looking for just a functions-only solution to this. I've included the problem in the excel file. Please feel free to ask any question for any clarification.

Thank you.

Attached Files

HELP!!.xlsx (13.5 KB, 9 views)

In H5, J5, H7 & J7, use:
=OFFSET($A$13,MATCH($F5,$A$13:$A$22,0)-1,MATCH(J$2,$A$13:$Q$13,0)-1)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you for your response. I've managed to get it to works with the INDIRECT function(which looks much more convoluted and confusing). I didn't know it had an OFFSET function and did around about way with COLUMN and ROW which make it looks like a nightmare.
Thank you again.