Formula to help select/suggest the best aircraft for a specific route

Hey Everyone

I'm trying to work out a formula that would 'Auto' Select the most suitable aircraft for a specific route, based on the following criteria


Problem Statement:- Which specific a) Aircraft is the most suitable for b) a specific route, based on:-
c) The flying range of the Aircraft - 1,000km - 18,000km
d) The length of the airport runway for both the departure airport and arrival airport - 3,117km - 15,010km
e) The runway length needed for any specific aircraft to land? In connection with (d) - 1,565km - 18,000km
f) The Stage (Cost) range of the Aircraft - 1 - 12 - meaning if i'm at cost stage 1 only Aircraft with that status should be considered
g) The Earnings/Cost Ratio of a specific Aircraft for a specific Route. -$10 to $10 - with the best (highest) E/C Ratio having met all other criteria being selected/suggested

I've attached an example of the base data being used to to try and answer the above, i'd really appreciate any thoughts/suggestions

Thank You

EDIT:- I've posted the same question on 1 other forum - as requested by admin (apologies again) here's the link - https://www.mrexcel.com/board/thread...ement.1254389/

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.

Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)

Sincere Apologies @6StringJazzer and Everyone

Here's the link Admin mentioned

https://www.mrexcel.com/board/thread...ement.1254389/

It won't happen again, my bad. Thank You for the instruction