Saving a value in another cell

N

networkjoe

I have a worksheet where using a table and vlookup, I enter a student's ID
number, and get their name. Then, using a nested IF statement I convert
their grade (0-100) into a letter grade (A-F).

let's say that the student's ID and score are entered in cells C2 and C3
respectively.

I would like that letter grade to then populate a table and save the grade.
Currently, when I enter the next ID and grade the previous one goes blank and
the new value is entered in the next cell.
 
B

Bernie Deitrick

Move C3 to D2, and put your formula in E2. Then copy E2 and paste it to E3:E100 (or how ever many
rows you have need for). Then enter your information into blank cells in columns C and D, and you
won't overwrite your previous values.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting multiple memberships 1
Omit empty cells? 0
problem with a function to calculate weighted test score 2
Help with Vlookup 1
COUNTIF 7
Custom Formating Letters to Numbers while Displaying Letters 2
Converting a letter grade to a numerical value 3
Lookup function 1

Top