Help With Spreadsheet-Automating?

Hi All,

Apologies in advance, I'm quite new to using excel, and would like some help with a spreadsheet I'm putting together.

I have 5 columns consisting of cill length a,b (merged cells) - cill width/depth c,d (merged cells) - quantity e,f (merged cells) - cost in euros g,h (merged cells) - cost in pounds i,j (merged cells).

Cill width consist's of a list of cill width's - each cill width has a cost. For example 50mm costs 5.35 euros, 150mm costs 11.12 euro's.

If I select from cell c,d 3 from the list 50mm, I would like cell g,h 3 to be entered automatically with 5.35 if quantity is 1, however if quantity is 2 for the 5.35 to double to 10.70 euros.

I would also like (if possible) the euro's cost to be converted to pounds automatically. For example 10.70 euros is £9.38 (would it be possible to have the exchange rate set at a fixed rate. i.e 0.96 per 1 euro)?

If anyone could give me some assistance, it would be greatly appreciated.