EXCEL: Need two values to match to give certain result

[rsutt1]

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

[malik641]

Hey rsutt1,

Welcome to the Forum!

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.

What do you mean by automate their selection?

Could you provide a small workbook example of your sample data and expected outcome? It sounds like you would only need formulas for this. All the data for Aircrafts and Airports could be on one sheet, and data analysis could be on another. But I'm not entirely sure on what it is that you're trying to accomplish.

[rsutt1]

I currently am using three sheets:

1. Quote Compiler
2. Airport Data
3. Aircraft Data

The way sheet 1 works is I select the aircraft, then the route it is due to fly.

I have worked it so it calculates everything apart from airport fees because it is dependant on data from both sheet 2 & 3. So any ideas??


While i'm here.....
I need a pop up box warning when a value goes below a certain point, how can this be acheived?

[Siddharth Rout]

While i'm here.....
I need a pop up box warning when a value goes below a certain point, how can this be acheived?

Check http://vbforums.com/showthread.php?t=448379

I have worked it so it calculates everything apart from airport fees because it is dependant on data from both sheet 2 & 3. So any ideas??

calculating airport fees shouldn't be difficult but it depends on what data you are looking up from sheet2 and sheet3 and what conditions should be met if there are any conditions... you need to explain it a bit more...