Update cells depending on an adjacent cells number

[debora]

I have a spread sheet. I contains in one of the columns scores. I would like the text in the adjacent cell to automatically update with text, depending on the score in the original column.

Eg If the score in H2 is 100, I’d like the cell I2 to say Full Compliance
If H3 has a score of 84 I’d like I5 to say Substantial Compliance… and so on

The scores are as follows

100 = Full Compliance
80 to 99 = Substantial Compliance
41 to 79 – Limited Compliance
40 or below = Little of No Compliance.

Can someone help me with this?

Many thanks

D

[Pete_UK]

You can do this with VLOOKUP, but before I can give you more details you had better change your title - read the Forum Rules.

Pete

[dilipandey]

Hi Debora,

Welcome to the forum.

Suggest you to change the title of your post to reflect the query you are asking, see the forum rules:-

http://www.excelforum.com/forum-rule...rum-rules.html

Regards,
DILIPandey

<click on below 'star' if this helps>

[Pete_UK]

Set up a table somewhere like this (assume it is in X1:Y4):

0 | Little or No Compliance
41 | Limited Compliance
80 | Substantial Compliance
100 | Full Compliance

Then in I2 you can use this formula:

=VLOOKUP(H2,$X$1:$Y$4,2)

and then copy down.

Hope this helps.

Pete

[debora]

Thank you so much

[Cutter]

If you are satisfied with the solution(s) provided, please mark your thread as Solved. Also, as a new member, you may not know that you can thank someone who has helped you by clicking the small star icon in the lower left corner of the post in which the help was given.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save