How can I Compare cells to find a price but allow the value to be changed.

[connor8392]

I have attached the spreadsheet I am working on.

What I need doing is:
I need the "Flight Valuation" page to link with the plane analysis page and bring back what the price would be if a certain plane was used for a certain destination.

If you need any more detail, feel free to ask.

Thank you for your time,
Connor.

[venkat1926]

is it possible to explain one manual calculation e.g for destination: "marmaris" and for 25 passengers from the data available in the sheet "plane analysis".

[Palmetto]

It's not clear exactly what you want to calculate, but here is a guess.
You want to . . .
Look up destination, return fuel costs and multiply by number of passenger to obtain a total price.

On the Flight Valuation sheet, you don't need combo boxes - use Data Validation (List option) so that selections can be directly referred to. Named ranges for Destination and MaxPassengers was created and used as the list source for each of the data validation cells.

This formula is used for price:
=INDEX('Plane Analysis'!$H$20:$H$42,MATCH('Flight Valuation'!$E$6,Destination,0))*$E$8

If this is not what you need then provide a more clear explanation and and examples of the desired results.