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
Bookmarks