Using Choose Function

[YasserKhalil]

Hello everyone
I have values in Column C starting in C4
I need a formula using choose function according the following :
The formula should be in D4
Values in Column C >> Results should be
------------------ -----------------
300 to 309 >> result should be 5
310 to 319 >> result should be 5.25
320 to 329 >> results should be 5.5

Thanks advanced

[azumi]

in D4 and copied down:

=IFERROR(LOOKUP(C4,{300,310,320},{5,5.25,5.5}),"")

[YasserKhalil]

Thanks for reply...I appreciate your help
I really need Choose function ...

[Tony Valko]

I really need Choose function ...

Why? CHOOSE is not the best solution.

=CHOOSE(MATCH(C4,{300,310,320}),5,5.25,5.5)

[azumi]

=lookup(c4,choose({1,2},{300;310;320},{5;5.25;5.5}))

[YasserKhalil]

Thank you very much for this great help
You are wonderful