Multiple vertical & horizontal lookup problem

[Hiruy]

Hi

I’m in need of a way of cross checking amount collect collected and price published. The ‘sales’ excel contains the sales data for September while the published Fares are ‘Fares’ excel.
- The Fares are published on origin- destination basis with respect to Classes designated by alphabets.


What I would like to do is bring the corresponding published fare of each sales line to the V column of the spreadsheet from the ‘fares’ excel using the criteria given on the G,H & I columns). Pls help me.