Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Vlookup student grades
Hi,
Thanks in advance for your time. I am trying to resolve a problem I am having with vlookups. I understand the concept pretty well so I am not sure what I am doing wrong. I have a list of grades for students A, A-, B+, B-, etc. and I have a list of corresponding number grades in column 2. I named the table "Grades". The row pairs are; A=100, A-=95, B+=90, B=85, B-=80. For some reason my B+ students are all getting 80. I wondered if vlookup was case-sensitive or if it didnt recognize + and - signs but even if it didnt, the B+ student should have an 85. Any thoughts, Thanks |
#2
|
|||
|
|||
Hi Vicky.
Is there a space between B and + in your table? -- Kind Regards, Niek Otten Microsoft MVP - Excel "Vicky" wrote in message ... Hi, Thanks in advance for your time. I am trying to resolve a problem I am having with vlookups. I understand the concept pretty well so I am not sure what I am doing wrong. I have a list of grades for students A, A-, B+, B-, etc. and I have a list of corresponding number grades in column 2. I named the table "Grades". The row pairs are; A=100, A-=95, B+=90, B=85, B-=80. For some reason my B+ students are all getting 80. I wondered if vlookup was case-sensitive or if it didnt recognize + and - signs but even if it didnt, the B+ student should have an 85. Any thoughts, Thanks |
#3
|
|||
|
|||
No, there isn't. Should there be? I dont think so. I will try.
"Niek Otten" wrote: Hi Vicky. Is there a space between B and + in your table? -- Kind Regards, Niek Otten Microsoft MVP - Excel "Vicky" wrote in message ... Hi, Thanks in advance for your time. I am trying to resolve a problem I am having with vlookups. I understand the concept pretty well so I am not sure what I am doing wrong. I have a list of grades for students A, A-, B+, B-, etc. and I have a list of corresponding number grades in column 2. I named the table "Grades". The row pairs are; A=100, A-=95, B+=90, B=85, B-=80. For some reason my B+ students are all getting 80. I wondered if vlookup was case-sensitive or if it didnt recognize + and - signs but even if it didnt, the B+ student should have an 85. Any thoughts, Thanks |
#4
|
|||
|
|||
At the end of your Vlookup, add a ",0)"
=vlookup("B+", table, 2 , 0) "Vicky" wrote: Hi, Thanks in advance for your time. I am trying to resolve a problem I am having with vlookups. I understand the concept pretty well so I am not sure what I am doing wrong. I have a list of grades for students A, A-, B+, B-, etc. and I have a list of corresponding number grades in column 2. I named the table "Grades". The row pairs are; A=100, A-=95, B+=90, B=85, B-=80. For some reason my B+ students are all getting 80. I wondered if vlookup was case-sensitive or if it didnt recognize + and - signs but even if it didnt, the B+ student should have an 85. Any thoughts, Thanks |
#5
|
|||
|
|||
Hi Duke,
What does that do? Does a 0 indicate that it must be an exact match? Thank you, it worked. Vicky "Duke Carey" wrote: At the end of your Vlookup, add a ",0)" =vlookup("B+", table, 2 , 0) "Vicky" wrote: Hi, Thanks in advance for your time. I am trying to resolve a problem I am having with vlookups. I understand the concept pretty well so I am not sure what I am doing wrong. I have a list of grades for students A, A-, B+, B-, etc. and I have a list of corresponding number grades in column 2. I named the table "Grades". The row pairs are; A=100, A-=95, B+=90, B=85, B-=80. For some reason my B+ students are all getting 80. I wondered if vlookup was case-sensitive or if it didnt recognize + and - signs but even if it didnt, the B+ student should have an 85. Any thoughts, Thanks |
#6
|
|||
|
|||
Vicky - You're right - it forces an exact match.
"Vicky" wrote: Hi Duke, What does that do? Does a 0 indicate that it must be an exact match? Thank you, it worked. Vicky "Duke Carey" wrote: At the end of your Vlookup, add a ",0)" =vlookup("B+", table, 2 , 0) "Vicky" wrote: Hi, Thanks in advance for your time. I am trying to resolve a problem I am having with vlookups. I understand the concept pretty well so I am not sure what I am doing wrong. I have a list of grades for students A, A-, B+, B-, etc. and I have a list of corresponding number grades in column 2. I named the table "Grades". The row pairs are; A=100, A-=95, B+=90, B=85, B-=80. For some reason my B+ students are all getting 80. I wondered if vlookup was case-sensitive or if it didnt recognize + and - signs but even if it didnt, the B+ student should have an 85. Any thoughts, Thanks |
#7
|
|||
|
|||
Duke,
What is the difference between putting a "0", or "false" at the end? -- Thanks, Ben "Duke Carey" wrote: Vicky - You're right - it forces an exact match. "Vicky" wrote: Hi Duke, What does that do? Does a 0 indicate that it must be an exact match? Thank you, it worked. Vicky "Duke Carey" wrote: At the end of your Vlookup, add a ",0)" =vlookup("B+", table, 2 , 0) "Vicky" wrote: Hi, Thanks in advance for your time. I am trying to resolve a problem I am having with vlookups. I understand the concept pretty well so I am not sure what I am doing wrong. I have a list of grades for students A, A-, B+, B-, etc. and I have a list of corresponding number grades in column 2. I named the table "Grades". The row pairs are; A=100, A-=95, B+=90, B=85, B-=80. For some reason my B+ students are all getting 80. I wondered if vlookup was case-sensitive or if it didnt recognize + and - signs but even if it didnt, the B+ student should have an 85. Any thoughts, Thanks |
#8
|
|||
|
|||
Just the spelling. Excel treats them the same.
Ben wrote: Duke, What is the difference between putting a "0", or "false" at the end? -- Thanks, Ben "Duke Carey" wrote: Vicky - You're right - it forces an exact match. "Vicky" wrote: Hi Duke, What does that do? Does a 0 indicate that it must be an exact match? Thank you, it worked. Vicky "Duke Carey" wrote: At the end of your Vlookup, add a ",0)" =vlookup("B+", table, 2 , 0) "Vicky" wrote: Hi, Thanks in advance for your time. I am trying to resolve a problem I am having with vlookups. I understand the concept pretty well so I am not sure what I am doing wrong. I have a list of grades for students A, A-, B+, B-, etc. and I have a list of corresponding number grades in column 2. I named the table "Grades". The row pairs are; A=100, A-=95, B+=90, B=85, B-=80. For some reason my B+ students are all getting 80. I wondered if vlookup was case-sensitive or if it didnt recognize + and - signs but even if it didnt, the B+ student should have an 85. Any thoughts, Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Function | Excel Worksheet Functions | |||
make a vlookup using a variable path | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
VLOOKUP not working | Excel Worksheet Functions |