You are welcome! Thanks for the feedback!
Stefi

"flyguykorea" wrote:

Thanks all for your replies.

Cheers

"Stefi" wrote:

I think the simplest way is to reformat your level table like this:
Sheet1
Col A Col B
0 Level 1
33 Level 2
50 Level 3
66 Level 4
78 Level 5
86 Level 6

If scores are in Sheet2
cols A B C D E F G
row 1: 72.2 72.9 64.8 48.1 63.0 66.7 64.6

then in Sheet2 H1 enter =VLOOKUP(MIN(A1:G1),Sheet1!$A$1:$B$6,2)

It returns Level 2.

Regards,
Stefi


€žflyguykorea€� ezt Ã*rta:

Complete novice with Excel...trying to use Vlokup which I think is the right
solution to my programming issue. Have tried to do it with help from the
Microsoft help system, but have failed. Any assistance is greatly appreciated!

I have a row of scores such as :
72.2 72.9 64.8 48.1 63.0 66.7 64.6

I want to award a Level based on the lowest score from above. I made another
worksheet with the information as such:

Level 6 86
Level 5 78
Level 4 66
Level 3 50
Level 2 33
Level 1 0

The scores above are the lowest scores to receive the indicated level. So, I
would like Excel to search the row of scores and award a level based on the
lowest score found.

Is Vlookup right? Can someone provide direction!? Thanks very much.