Help with Vlookup
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.
|