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" <Vicky@discussions.microsoft.com> wrote in message
news:4044E6C9-B4FC-40FC-BBD0-D3779D3B156D@microsoft.com...
> 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" <Vicky@discussions.microsoft.com> wrote in message
> news:4044E6C9-B4FC-40FC-BBD0-D3779D3B156D@microsoft.com...
> > 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