Excel formula creation - help needed

[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

 

[CanadaRAM]

Look in Excel Help for the function

VLOOKUP

 

[exegete77]

Keep in mind that VLOOKUP works fine as long as the lookup values are alphabetical and it is the left hand column. To get around those problems, use the much more flexible INDEX/MATCH combination., which allows lookup based on any row or any column.

=INDEX(Data,MATCH(ColAValue,ColA,FALSE),MATCH(RowValue,Row,FALSE)