# Advice - allocating points to value

#### Mark0123

##### New Member
Hi,

I have a list of scores in column A from 0-100 and am trying to allocate points depending on their scores in column B.

Criteria;
<50 = 100 points
51-80 = 200 points
81-100 = 300 points

I am able to do this a long way using look-ups but was wondering if anybody knows a tighter formula?

### Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Try

=LOOKUP(A1,{0,51,81,101},{100,200,300,0})

You don't say what if over 100?

Hi Mark

Tighter than with Lookup()?

I don't see how.

This is the lookup I'd use, similar to gaz_chops's:

=LOOKUP(A1,{0,100;51,200;81,300})

Hi Mark

Tighter than with Lookup()?

I don't see how.

This is the lookup I'd use, similar to gaz_chops's:

=LOOKUP(A1,{0,100;51,200;81,300})

Even neater, I always forget that option!

Replies
0
Views
259
Replies
10
Views
244
Replies
1
Views
87
Replies
1
Views
244
Replies
6
Views
265

1,207,261
Messages
6,077,356
Members
446,279
Latest member
hoangquan2310

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