EXCEL: Need two values to match to give certain result
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
Re: EXCEL: Need two values to match to give certain result
Hey rsutt1,
Welcome to the Forum! :)
Quote:
Originally Posted by rsutt1
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.
Re: EXCEL: Need two values to match to give certain result
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?
Re: EXCEL: Need two values to match to give certain result
Quote:
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
Quote:
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...
