Conditional search

Hello,

I'm trying to write a formula to display revenues by month. Due to our reporting format the source data is displayed

T+1 T+2
Month License Consultancy Month License Consultancy

May-10 13,200 11,880 Jun-10 13,200 33,825
Jun-10 9,450 4,050 Jul-10 9,450 20,513
Jan-10 8,250 8,910 Feb-10 8,250 22,688
Aug-10 7,500 2,700 Aug-11 7,500 16,875

(Note - T + 2 should be displayed above the second Month/License/Consultancy)

I need to run a search by row (by client) to find a certain month and once I have found it, display either the license revenue or consultancy revenue in the cell.

I have searched the internet without any luck. Could you please advise what is the easiest way to solve this?

Thanks