You can do it with an INDEX formula. Can you post an example workbook? Then I'll be able to come up with a formula that suits your particular set-up.

Pete