get the last value in column (mimicking a hierarchy structure)

I currently have some vlookup formulas set up as so. An example cell formula would be

=IF($F2=G$1,$C2,"")

My current situation

Basically, the hierarchical data was stored in the database in numerical form. (ie, level 1 = 1, level 2 = 2, etc)

Ideal output

I would need some formula for the "value if false" portion of my above 'if' statement. Essentially, it would grab the last value in the column (the 'red' values). Notable exception is when it's a new value (see the yellow cells), and that case it's blank.