dragging a formula down through cells

[anthony.maddick]

hello everyone, I'm having a little bit of a drama with a simple worksheet.
As you can see in the sheet i have a formula worked out that gives me a total depending on the letter that is in the "code" B2 cell- it matches the letter from the codes from the right and enters the value associated. all works fine however i need to use the same formula for over 200 cells leading down but when i drag it down the formula changes and then doesn't work. Can alone advise it there is a way to drag it down or another formula to use.
my actual sheet has 11 codes and over 200 cells down so typing them is a lot of work and I'm trying to avoid it.
Thanks in advance

[canapone]

Hi,

in H2:I100 your costs table, maybe

=VLOOKUP(B2,$H$2:$I$100,2;0)


Hope it helps

[romperstomper]

In C2:
=IFERROR(VLOOKUP(B2,$H$2:$I$6,2,FALSE),0)
and copy down.

[Special-K]

=VLOOKUP(B2,H$2:I$6,2,0)
and copy down to B6

[Punnam]

Just for knowledge

The above or friendly and good enough
=INDEX($I$2:$I$6,MATCH(B2,$H$2:$H$6,0))
=INDIRECT(ADDRESS((MATCH(B2,$H$2:$H$6,0)+1),COLUMN(I2)))
Punnam

Punnam