software

cell A2 contains text: Grade. Cells A2:B6 contain 0 to 49= F, 50 to 59= D, 60
to 74= C, 75 to 89= B, 90 to 100=A.Each letter grade should be matched up
with the lowest score possible for that grade. Using the insert,function,
Vlookup table I can not get what to put in each of the 4 categories except
for False. Please Help! Thank you.

See if this works for you:

On a separate sheet, build this table:
0F
50D
60C
75B
90A
(I'll assume that table is in cells A1:B5 on Sheet2)

Then, for a number grade in A2 on Sheet1:
B2: =VLOOKUP(A2,Sheet2!$A$1:$B$5,2,TRUE)

Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Karaoke2ladyquot; wrote:

gt; cell A2 contains text: Grade. Cells A2:B6 contain 0 to 49= F, 50 to 59= D, 60
gt; to 74= C, 75 to 89= B, 90 to 100=A.Each letter grade should be matched up
gt; with the lowest score possible for that grade. Using the insert,function,
gt; Vlookup table I can not get what to put in each of the 4 categories except
gt; for False. Please Help! Thank you.

Assume the numeric values are in A2:A60 and the grade letters in B2:B6,
create a table like this

0 F
50 D
60 C
75 B
90 A

assume you put the score in C2 then use either

=VLOOKUP(C2,A2:B6,2)

or

=LOOKUP(C2,A2:A6,B2:B6)If you want to skip the table altogether

=VLOOKUP(C2,{0,quot;Fquot;;50,quot;Dquot;;60,quot;Cquot;;75,quot;Bquot;;90,quot;Aquot;},2)

or

=LOOKUP(C2,{0;50;60;75;90},{quot;Fquot;;quot;Dquot;;quot;Cquot;;quot;Bquot;;quot;Aquot;})

you might want to add something in case C2 is empty=IF(C2=quot;quot;,quot;quot;,VLOOKUP(C2,A2:B6,2))--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

quot;Karaoke2ladyquot; gt; wrote in message
news
gt; cell A2 contains text: Grade. Cells A2:B6 contain 0 to 49= F, 50 to 59= D,
gt; 60
gt; to 74= C, 75 to 89= B, 90 to 100=A.Each letter grade should be matched up
gt; with the lowest score possible for that grade. Using the insert,function,
gt; Vlookup table I can not get what to put in each of the 4 categories except
gt; for False. Please Help! Thank you.Try this:

Viewgt;Page Break Preview

For individual manually inserted page breaks:
Drag them off the page

To clear ALL manually inserted page breaks:
Right-click in any cell and select: Reset all page breaks

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Karaoke2ladyquot; wrote:

gt; cell A2 contains text: Grade. Cells A2:B6 contain 0 to 49= F, 50 to 59= D, 60
gt; to 74= C, 75 to 89= B, 90 to 100=A.Each letter grade should be matched up
gt; with the lowest score possible for that grade. Using the insert,function,
gt; Vlookup table I can not get what to put in each of the 4 categories except
gt; for False. Please Help! Thank you.

Sorry, I have no idea how that post ended up in this thread.

I'm guessing it's a hardware problem:
A loose nut in front of my keyboard!

***********
Regards,
Ron

XL2002, WinXP-Proquot;Ron Coderrequot; wrote:

gt; Try this:
gt;
gt; Viewgt;Page Break Preview
gt;
gt; For individual manually inserted page breaks:
gt; Drag them off the page
gt;
gt; To clear ALL manually inserted page breaks:
gt; Right-click in any cell and select: Reset all page breaks
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Karaoke2ladyquot; wrote:
gt;
gt; gt; cell A2 contains text: Grade. Cells A2:B6 contain 0 to 49= F, 50 to 59= D, 60
gt; gt; to 74= C, 75 to 89= B, 90 to 100=A.Each letter grade should be matched up
gt; gt; with the lowest score possible for that grade. Using the insert,function,
gt; gt; Vlookup table I can not get what to put in each of the 4 categories except
gt; gt; for False. Please Help! Thank you.

LOL!

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

quot;Ron Coderrequot; gt; wrote in message
...
gt; Sorry, I have no idea how that post ended up in this thread.
gt;
gt; I'm guessing it's a hardware problem:
gt; A loose nut in front of my keyboard!
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt;gt; Try this:
gt;gt;
gt;gt; Viewgt;Page Break Preview
gt;gt;
gt;gt; For individual manually inserted page breaks:
gt;gt; Drag them off the page
gt;gt;
gt;gt; To clear ALL manually inserted page breaks:
gt;gt; Right-click in any cell and select: Reset all page breaks
gt;gt;
gt;gt; Does that help?
gt;gt;
gt;gt; ***********
gt;gt; Regards,
gt;gt; Ron
gt;gt;
gt;gt; XL2002, WinXP-Pro
gt;gt;
gt;gt;
gt;gt; quot;Karaoke2ladyquot; wrote:
gt;gt;
gt;gt; gt; cell A2 contains text: Grade. Cells A2:B6 contain 0 to 49= F, 50 to 59=
gt;gt; gt; D, 60
gt;gt; gt; to 74= C, 75 to 89= B, 90 to 100=A.Each letter grade should be matched
gt;gt; gt; up
gt;gt; gt; with the lowest score possible for that grade. Using the
gt;gt; gt; insert,function,
gt;gt; gt; Vlookup table I can not get what to put in each of the 4 categories
gt;gt; gt; except
gt;gt; gt; for False. Please Help! Thank you.