Adding multiple answers to an IF OR formula

[MOSBEIUK]

Hi guys,

Your officially my Excel mentors I hope you dont mind!

I am using the forumla =IF(OR(E2="COLD"),"33%")

Which kindly changes my cell to show the text 33% if the text cold is entered into cell E2. Now what I would like to know, is if I can add multiple catch words to give alternate pre defined percentages. Such as warm and hot to give the respective answers as 66% and 99%

Your help is always appriciated!

[FDibbins]

I would use VLOOKUP() for this.

1st, create a small table, as shown below...

	A	B	C	D	E
1	Cold	33%
2	Warm	66%			Cold
3	Hot	100%
4	Steaming	133%
5
6
7	33%

A7=VLOOKUP($E$2,$A$1:$B$4,2,0)

You could expand on this, such that if you had a value in F2 that you wanted to apply the % to...

A7=F2*VLOOKUP($E$2,$A$1:$B$4,2,0)

(Good thread title, btw)

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[AlKey]

Maybe this one

=INDEX({"33%","66%","99%"},MATCH(A2,{"Gold","Silver","Bronze"},0))

	A	B
1	Key Word	%
2	Gold	33%
3	Silver	66%
4	Bronze	99%
5	Silver	66%
6	Gold	33%