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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Vlookup
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Vlookup
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Vlookup
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Vlookup
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. |
Reply |
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 |