Excell macro work sheet

I have data, need to have price displayed to quote for customer.
Product is a automotive car battery.
Customer input is his car model details.Data provided dinamic.
Need to fetch suitable car battery part code from different brands and ranges. Data mapping provided
Need to select price from the price list
Provide discount for exchange depending on wt of old battery and current scrap price.
Display with optional discount, fitting charges in a presentable pritable manner.

All sample data provided and will be dinamic as u uderstand.

Can give more detail on requirements