Need formula to find a value and then track its movement?

[Tamm7]

Hi,

I would like to track the movement of specific student in column B and use her value in column c, and track her updated movement in Column F, with the value in column G.

Sorry if confusing, this may help:

COLUMN B...............COLUMN C..........COLUMN F..........COLUMN G
Lulu (Previous)............20000 points........Lulu (Updated).....774 points
Stacy (Previous).........1534 points..........Stacy (Updated)....2324 points
Elliot (Previous)...........234 points............Elliot (Updated)....233 points
Jack (CPrevious)...........474 points...........Jack (Updated).....679 points

 

[Marcílio_Lobão]

Tamm7, Good afternoon.

I'm sorry but I could not understand exactly what your need is.

Please give us an example of what the answer would be and how it would be obtained.