Hello again, only been a member on these forums for a day and realised they are great. My latest problem:

I am working on a system that gives information on Aircraft and Airports however some information is dependant on both.

I am using VLOOKUP to bring in the airport and aircraft data.

One example is landing fees, obviously certain aircraft weigh different weights and certain airports have different landng rates so there is my dilemma. We only have three aircraft so it wouldnt be a problem storing the 3 fees in my airport list but how do i automate their selection.


Many Thanks