I am compiling a workbook which has several sheets. The first is the main
sheet, the rest contain data whic I need to reference, (a courier companies
rates for example).

I need to be able to check that two cells of the main sheet match (e.g. cell
b1 = "New York" and cell c1 = "[name of courier company]" (as opposed to sea
freight / road freight etc). Then look in cell d1 for the # kilos. I then
need to check [courier rate] sheet for corresponding kilos and then
appropriate rate for that number of kilos, which should be returned as a
value in the main sheet.

I think it is Vlookup, but it's not simple, any ideas please?
Jamie