Linking Cells In a Dropdown Box

[Kerry78]

Hi,

I am not very good at explaining, but I have a painting company and I am creating a spreadsheet to price jobs.

I want to be able to click on a dropdown box, select a painting description(e.g: To Paint Ceilings) and have excel automatically pull up a cell beside it with the price for painting ceilings.

e.g To Paint Ceilings - $1.00
To Plaster Walls - $2.00

The reason I want the spreadsheet set out this way is so I can then calculate the price in the second cell based on the room measurements in the third cell, which I am able to do myself.

e.g.
Description - Price - Area (M2) - Total Cost
To Paint Ceilings - $1.00 - 5 - $5.00
To Plaster walls - $2.00 - 20 - $40.00

I hope this makes sense and that somebody can help me.
Thanks in advance
Kerry