Setting vlookup Parameters

[Graywolf80]

Im trying to setup my key for lookup parameters. Is there a way to set a range for it look for in one cell?

Example, If a product ends up being 89.9% in one cell, and I am asking another cell to display its end result with a word.

In my legend/key can I place the range of 80%-90% in the 1 column and Excellent in the 2nd column.


How can I make this work? Or do I have to use each percentage in a seperate cell with the description next to each?

Thanks in advance, and hope this wasnt too confusing.

 

[AlphaFrog]

Excel Workbook
	A	B	C	D	E
1	89.9%	Excellent		Range Min	Result
2	55.0%	Poor		0%	Fail
3	45.0%	Fail		50%	Poor
4	90.0%	Wow		70%	OK
5				80%	Excellent
6				90%	Wow
Sheet

 

[Graywolf80]

Thank you very Much!!!!

 

[AlphaFrog]

You're welcome.

FYI: You could put the "legend/key" within the formula...
=LOOKUP(A1,{0,0.5,0.7,0.8,0.9},{"Fail","Poor","OK","Excellent","Wow"})

 

[GNB]

You could also use vlookup but using TRUE at the end that will have the same effect.