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.

F 1090150	G SP33	H SP33
1090150		SP33
1090150		SP33
1090150		SP33
1090150		SP33
1090150		SP33
1090150		SP33

<tbody>
</tbody>

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).