Look at this tutorial:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"flyguykorea" wrote in message ...
| 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.