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

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

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

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

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

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

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

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