I have 5 (Five) data inputs... one is variable and is dependant on the input value (so looking for a range) three are columns and one is a row... complicated I know.
Unless I'm missing an easy way (which is possible), I don't think that's going to be easy in a spreadsheet, but it should be straightforward in a database.
If this is something you are going to use long-term, with additions and changes to the table of rates, then I'd suggest doing it in a database application.
If you want to do it in a spreadsheet anyway, let us know.
Based upon your current table, you don't have all of the data for the choices (e.g., you currently don't have any results if its myHermes & Courier_Collection). Additionally, there's a column of data (Col M) in your spreadsheet that isn't factored in your data from Col A - E. Is this related to insurance of the item/ it's costs (e.g., for MyHermes, Pacel_Drop_Off, Parcel in col M you have values from 0 to 250.1)