Take a look at the VLOOKUP function.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Derrick Robinson" wrote in message
news:C2ume.4604$zb.3814@trndny06...
I created an advertising opportunity score sheet. When I arrive
at the total score I would like excel to display some words
telling what the number means in terms of advertising
opportunity
Examples - If the total is any of the following the text should
be displayed below the score or beside the score.

.90 - 1.0 = extraordinary opportunity
.80 - .89 = excellent opportunity
.70 - .79 = very good
.60 - .69 = good
.50 - .59 = average opportunity
.40 - .49 = poor
,30 - .39 = very poor

I hope I am making sense.
Thank you

Derrick