# Vlookup

#### Randy Hill

##### New Member
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

### Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Try

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

Last edited:
Gaz_Chops you are a life saver. Thank you so much.

You're welcome.

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"})

Replies
0
Views
131
Replies
19
Views
330
Replies
12
Views
849
Replies
5
Views
422
Replies
20
Views
631

1,203,224
Messages
6,054,237
Members
444,711
Latest member
Stupid Idiot

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back