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