# Multiple arguments in the same cell

#### kastertroy

##### New Member
I am attempting to have a certain percentage reflect in one cell.

For example:

if cell (i4) is greater than 299 then I want .23 to be the value, if less than 299, .17 and if cell (i4) is greater than 399 then I want .27 to be the value, if less than 399, .23, and if cell (i4) is greater than 499 then I want .35 to be the value, if less than 499, .27.

Confused??? Well, I am!

Is there a way to articulate that? If necessary, I can paste the worksheet in here so you can see what I'm trying to do, if in fact we are allowed to do so.

Thanks in advance for the help.

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
please help

See the Help files for,

LOOKUP or VLOOKUP.

or look at the bottom of this page to upload Colo's HTML utility to post a small sample of data.....

try this
Book1
DEFGHI
1LookupsPercent
200.17
32990.23AnswerLookup
43990.270.17150
54990.35
6
Sheet1

formula in H4
=VLOOKUP(I4,D2:E5,2)

Looks good but, I want to drag that formula down for that whole column. When I did that, the data range would follow in succession, which eliminates where I'm pulling my data from. How can I fix that?

Thanks a million!

Use \$ signs to anchor your references, if I understand you --

\$D\$2:\$E\$5

will remain that reference when copied/dragged to other cells.

good looking! This place is fantastic!!!

try this
Book1
DEFGHI
1LookupsPercent
200.17
32990.23AnswerLookup
43990.270.17150
54990.35
6
Sheet1

formula in H4
=VLOOKUP(I4,D2:E5,2)

Just_jon, is there another way of doing performing this task besides vlookup?

VLOOKUP's probably as efficient as you're going to get, unless there's a reason not to use it -- having to do a lookup to the left, for instance.

Replies
2
Views
73
Replies
3
Views
112
Replies
3
Views
308
Replies
12
Views
293
Replies
3
Views
100

Threads
1,217,677
Messages
6,137,943
Members
450,100
Latest member
mscetr

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

### Disable AdBlock

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