Excel formula creating help - lookup

[h2009]

Hi there, Im trying to find the formula which will look a lookup and return a result i.e. heres a simple example:

Row A                Row B	   Row C

bulb 1                0.152	   0.227
bulb 2                0.149	   0.224
bulb 3                0.034	   0.051
bulb 4                0.148	   0.222
bulb 5                0.022	   0.033

Row A                Row  B                                           Row C   Row D
Bulb cost  ----->  (i want to type in bulb X) > returns with	   0.034	0.051

Is it possible to make a formula which can do this?

thank you

 

[h2009]

Thank you for your help just what i needed!

Just another quick question is it possible i to match the lookup cell (B8) -
i.e. instead of typing 'bulb 3' i could type '3' - without changing the name of the cell

so if i have the countries albania, algeria - and by typing alb (i.e. looks up intelligently) and returns albania?