Perhaps a combination of Data Validation drop downs and Vlookup. Where the
drop down offer the various selections of options and the vlookup produces
the price for that option.

HTH
Regards,
Howard

"trailerman" wrote in message
ps.com...

Hi,
I sell trailers and need to produce quotations.

There are six different types in a group. i.e Powder=SSK60, SSK65, SS70
and so on.

With each tank there are options ie number of hatches possible answer
1to 6, axle type possible answer saf or bpw, and so on

Is it simple or beyond the scope of a new starter?

Regards