Vlookup

[Randy Hill]

Help please. I have a vlookup that does not work properly and can not figure it out.

Cell D28 is the number of students in a class, depending of the number the price will change.

This is what I have
=LOOKUP(D28{0,0;4,"$65.00";9,"$75.00";10,"$100.00";15,"$150.00"})

1-4 students should show $65.00
5-9 students should show $75.00
10-14 students should show $100.00
15 or more should show $150.00

everything works but the 5-9 range, it still shows a price of $65.00

Thanks

 

[gaz_chops]

Try

=LOOKUP(D28,{0,5,10,15},{"$65.00","$75.00","$100.00","$150.00"})

 

[Randy Hill]

Gaz_Chops you are a life saver. Thank you so much.

 

[gaz_chops]

You're welcome.

 

[gaz_chops]

Realised that 0 should prob return zero, so

=LOOKUP(D28,{0,1,5,10,15},{0,"$65.00","$75.00","$100.00","$150.00"})

Your version which I'd not seen done before!

=LOOKUP(D28,{0,0;1,"$65.00";5,"$75.00";10,"$100.00";15,"$150.00"})