Saving a value in another cell

  • Thread starter Thread starter networkjoe
  • Start date Start date
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.
 
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
COUNTIF 7
Custom Formating Letters to Numbers while Displaying Letters 2
Help with Vlookup 1
Converting a letter grade to a numerical value 3
problem with a function to calculate weighted test score 2
COUNTIF Question 12

Back
Top