I want to be able to automatically generate price confirmations / quotes by
entering the

MAIN TABLE
Product Price1 Price2 Delivery
P1 €183 €172 8-12
P2 €195 €195 30
P3 €412 €70 30
P4 €293 €183 30+

Calculation Table
P2
P4

Here I would type in or select from a dropdown the product P2 & P4 and the
other cells would be automatically completed (lookedup?) using the adjacent
cell reference.

Sure this isn't too complex just need some help from someone with a bit more
knowledge on such items. Thank you in anticipatio of your assistance.