VLOOKUP to lookup an un-named column

OK im not very good when it comes to these usually so todays mini project on a monday confussed me.

The attached is what im working on.

Sheet 1 contains the data. Sheet 2 is the user entry form. and Sheet 3 contains the Named ranges that populate the drop downs in sheet 2.

I need the VLOOKUP to be able to query as follows

from = sheet 1 B:B
to = sheet 1 C:C

thats easy enough i think but heres the difficulty

Pass Type (TicketType) = the relavant price for the travel cost required.

Thanks in Advance