Help with Vlookup

[Guest]

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.

 

[Niek Otten]

Look at this tutorial:

http://www.contextures.com/xlFunctions02.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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.

 

[Guest]

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:

 

[Guest]

Thanks all for your replies.

Cheers

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:

 

[Guest]

You are welcome! Thanks for the feedback!
Stefi

Thanks all for your replies.

Cheers