Overwrite previous cells Help!

[KiloHotel]

Hi Guys,

Can someone assist with this issues that I am having,

Right now I have this on Excel in columns FGH and I have it filtered by 1090150 in column F for now for simplicity.


[TABLE="class: cms_table, width: 216"]
<tbody>[TR]
[TD="class: cms_table_xl67, width: 64, align: center"]F

1090150[/TD]
[TD="class: cms_table_xl67, width: 76, align: center"]G

SP33[/TD]
[TD="class: cms_table_xl67, width: 76, align: center"]H

SP33[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl67, align: center"]1090150[/TD]
[TD="class: cms_table_xl67, align: center"][/TD]
[TD="class: cms_table_xl67, align: center"]SP33[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl67, align: center"]1090150[/TD]
[TD="class: cms_table_xl67, align: center"][/TD]
[TD="class: cms_table_xl67, align: center"]SP33[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl67, align: center"]1090150[/TD]
[TD="class: cms_table_xl67, align: center"][/TD]
[TD="class: cms_table_xl67, align: center"]SP33[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl67, align: center"]1090150[/TD]
[TD="class: cms_table_xl67, align: center"][/TD]
[TD="class: cms_table_xl67, align: center"]SP33[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl67, align: center"]1090150[/TD]
[TD="class: cms_table_xl67, align: center"][/TD]
[TD="class: cms_table_xl67, align: center"]SP33[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl67, align: center"]1090150[/TD]
[TD="class: cms_table_xl67, align: center"][/TD]
[TD="class: cms_table_xl67, align: center"]SP33[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl67, align: right"][/TD]
[TD="class: cms_table_xl67"][/TD]
[TD="class: cms_table_xl67"][/TD]
[/TR]
</tbody>[/TABLE]

I am using this VLOOKUP in the H Cells to produce what you see above; =VLOOKUP(F3,$F$3:$G$9999,2,FALSE())

This sheet is 2000+ rows of data and what I want to do is if add in a different value (Not SP33) for example halfway down column G somewhere in the mid thousands then whatever is in was in column G previously against 1090150 will change to the new value which in turn will change whatever is in Column H on all of them.

Let me know if that makes sense because I'm sure I may have murdered that explanation

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...g-cell-overwrite-post5151363.html#post5151363

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).