Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |