Multiple If Statement

[montanaaggie]

I have a range of data in cells A1: C4
0% 15% CO2
15% 40% WATER
40% 60% CO2
60% 100% WATER

I then have a data point in D4 that is calculated based on a equation. I would like to have an equation in E4, that would look at the number in D4 and bring back its corresponding match in C4. Example 16% it would display Water, at 45% it would display CO2. I'm not exactly sure how to structure my IF statement to have this work.

Thanks,
Dave

 

[bbott]

Hi Dave,

Try this in E4:

=CHOOSE(MATCH(D4,{0,0.149,0.399,0.599,1.01},1),"CO2","Water","CO2","Water")

 

[jim may]

Will this work for you?

Excel 2012
	A	B	C	D	E
1	0%	15%	CO2
2	15%	40%	WATER
3	40%	60%	CO2
4	60%	100%	WATER	16%	WATER
Sheet1

Cell Formulas
Range	Formula
E4	=LOOKUP(D4,A1:A4,C1:C4)

 

[liveinhope]

=vlookup(d1,$a$2:$c$4,3)

 

[Weazel]

what are you expecting to see if the value is 15%, 40% or 60% exactly?

using your table based off the values in column A you could use somthing like

=LOOKUP(D4,A1:C4)

 

[pam53154]

I think the easiest approach in E4 is =vlookup(D4,A1:C4,3,TRUE). The TRUE clause will return the closest match which seems to be what you want. Usually vlookup uses FALSE which returns a value only with an exact match.

 

[montanaaggie]

Thanks for the help. I don't know why I didn't think about using a vlookup. That does seem to be the easiest method

 

[jim may]

It's not a "v"lookup;
"it is the lookup function.
Jim

 

[liveinhope]

It's not a "v"lookup;
"it is the lookup function.
Jim

Both lookup (as in Jim's formula ) and vlookup (as in formulas from myself and pam53154) will work. It's just matter of personal preference.