Need to add set amounts to a price list with different criteria

[Longshot9921]

Hi, I need to add different amounts to a column of prices based on a column of zone numbers.
I don't know if that makes sense but here is an example test.xlsx

thanks
Longshot9921

[BadlySpelledBuoy]

Try this in C2 and copy down:
=B3+VLOOKUP(A3,G$10:H$16,2,FALSE)

[Sam Capricci]

this would work though it isn't very elegant.
=IF($G$10=A2,B2+$H$10,IF($G$11=A2,B2+$H$11,IF($G$12=A2,B2+$H$12,IF($G$13=A2,B2+$H$13,IF($G$14=A2,B2+$H$14,IF($G$15=A2,B2+$H$15,B2+$H$16))))))

[newdoverman]

This is another way to match up the data and make the calculation.

Please Login or Register  to view this content.