Multiple arguments in the same cell

kastertroy

New Member
Joined
Sep 7, 2006
Messages
4
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

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,458
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.....
 

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
try this
Book1
DEFGHI
1LookupsPercent
200.17
32990.23AnswerLookup
43990.270.17150
54990.35
6
Sheet1


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

kastertroy

New Member
Joined
Sep 7, 2006
Messages
4

ADVERTISEMENT

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!
 

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
Use $ signs to anchor your references, if I understand you --

$D$2:$E$5

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

kastertroy

New Member
Joined
Sep 7, 2006
Messages
4
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?
 

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,804
Messages
5,638,455
Members
417,025
Latest member
MusterDuster

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?

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
Top