# Lookup result from percentage cell

#### BrownBarry

##### New Member
Hi I am trying to put a value in a cell by looking up a cell that contains a percentage number.

The formula I am using at the moment is
=LOOKUP(O5,{0,25,50,75},{"1","2","3","4"})

It works on a number cell but not percentage.

Can anyone tell me what the problem is.

Thanks

### Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use \$ signs: \$V\$2:\$Z\$99 will always point to V2:Z99, even after copying

#### mfexcel

##### Well-known Member
For percentage, try:
=LOOKUP(A5,{0,25,50,75}/100,{"1","2","3","4"})

#### BrownBarry

##### New Member
For percentage, try:
=LOOKUP(A5,{0,25,50,75}/100,{"1","2","3","4"})

Thanks for the reply.
The result is 4 but the percentage is 57%. It should read 3 should it not.

#### mfexcel

##### Well-known Member
Are you sure you have input 57%, but not 57?

Thanks for the reply.
The result is 4 but the percentage is 57%. It should read 3 should it not.

#### BrownBarry

##### New Member
Are you sure you have input 57%, but not 57?

Yes the cell I am referencing contains 57% so the formula you gave me should give me 3 as the result.

Thanks

Replies
7
Views
344
Replies
3
Views
318
Replies
2
Views
126
Replies
4
Views
183
Replies
11
Views
193

1,191,624
Messages
5,987,742
Members
440,106
Latest member
davcurnutt

### 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.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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