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="width: 216"]
<tbody>[TR]
[TD="class: xl67, width: 64, align: center"]F
1090150[/TD]
[TD="class: xl67, width: 76, align: center"]G
SP33[/TD]
[TD="class: xl67, width: 76, align: center"]H
SP33[/TD]
[/TR]
[TR]
[TD="class: xl67, align: center"]1090150[/TD]
[TD="class: xl67, align: center"][/TD]
[TD="class: xl67, align: center"]SP33[/TD]
[/TR]
[TR]
[TD="class: xl67, align: center"]1090150[/TD]
[TD="class: xl67, align: center"][/TD]
[TD="class: xl67, align: center"]SP33[/TD]
[/TR]
[TR]
[TD="class: xl67, align: center"]1090150[/TD]
[TD="class: xl67, align: center"][/TD]
[TD="class: xl67, align: center"]SP33[/TD]
[/TR]
[TR]
[TD="class: xl67, align: center"]1090150[/TD]
[TD="class: xl67, align: center"][/TD]
[TD="class: xl67, align: center"]SP33[/TD]
[/TR]
[TR]
[TD="class: xl67, align: center"]1090150[/TD]
[TD="class: xl67, align: center"][/TD]
[TD="class: xl67, align: center"]SP33[/TD]
[/TR]
[TR]
[TD="class: xl67, align: center"]1090150[/TD]
[TD="class: xl67, align: center"][/TD]
[TD="class: xl67, align: center"]SP33[/TD]
[/TR]
[TR]
[TD="class: xl67, align: right"][/TD]
[TD="class: xl67"][/TD]
[TD="class: 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.
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="width: 216"]
<tbody>[TR]
[TD="class: xl67, width: 64, align: center"]F
1090150[/TD]
[TD="class: xl67, width: 76, align: center"]G
SP33[/TD]
[TD="class: xl67, width: 76, align: center"]H
SP33[/TD]
[/TR]
[TR]
[TD="class: xl67, align: center"]1090150[/TD]
[TD="class: xl67, align: center"][/TD]
[TD="class: xl67, align: center"]SP33[/TD]
[/TR]
[TR]
[TD="class: xl67, align: center"]1090150[/TD]
[TD="class: xl67, align: center"][/TD]
[TD="class: xl67, align: center"]SP33[/TD]
[/TR]
[TR]
[TD="class: xl67, align: center"]1090150[/TD]
[TD="class: xl67, align: center"][/TD]
[TD="class: xl67, align: center"]SP33[/TD]
[/TR]
[TR]
[TD="class: xl67, align: center"]1090150[/TD]
[TD="class: xl67, align: center"][/TD]
[TD="class: xl67, align: center"]SP33[/TD]
[/TR]
[TR]
[TD="class: xl67, align: center"]1090150[/TD]
[TD="class: xl67, align: center"][/TD]
[TD="class: xl67, align: center"]SP33[/TD]
[/TR]
[TR]
[TD="class: xl67, align: center"]1090150[/TD]
[TD="class: xl67, align: center"][/TD]
[TD="class: xl67, align: center"]SP33[/TD]
[/TR]
[TR]
[TD="class: xl67, align: right"][/TD]
[TD="class: xl67"][/TD]
[TD="class: 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.
Last edited: