Excel Help - Vlookup

[Atomic]

I want to know if this is possible and what the code is for my Vlookup problem.

I have a work sheet with the following:
- Column C34 to C42 will contain statistical data that's in percentage.
- Columns D34 to D42 will contain the Vlookup
- For now, Columns F34 to f40 and g34 to g40 will contain the data I want the vlookup to bringup.
- Below is the copy and paste job of cells f34 to f37 and g34to g37. I want in cell D34 for example to have the word 'Excellent', 'Very Good', or 'Good' to appear if a value is met in cell C34. So if I have the figure in cell C34 of 91% I want in cell D34 to have the word 'Excellent Appear', but if I input the statistic of say ' '79%' then I want 'Very Good' to appear.

Is this possible, and can anyone help me.

This is my vlookup that's not working: =VLOOKUP(C34,F33:G40,2,TRUE)

Excellent 90%-100% Very Good 75%-90% Good 25 Average 45%-60% Below Average 30%-45%

 

[|Ric|]

I have attached a screen shot of this working and the formula is showing in the formula bar.

Points to look out for is the table needs to be sorted in ASCENDING order otherwise it will not give the correct results.
Also as always, absolute references to the vlookup table

 

[|Ric|]

Also you might want to lower the range of below average to 0 because if there is a mark less than 30 at the moment you get N/A
It really depends if it is actually possible to get a mark that low

 

[Atomic]

Thank you very much for your help