Cross checking published fare with actual sales

Hi Guys

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.
- Fares from 1-58 are published based on a city to or from ADD with respect to Classes designated by alphabets.
- Line 59 is between cities DUB & LAX
- Line 60 is for any other combination

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.