K
kukarooza
Thanks in advance to anyone who can help me resolve this issue.
I've got a column of data that has the following formula in each cell:
=VLOOKUP(G52,Q3:R151,2,1)
I initially put this formula in the H2 cell and then copied it dow
through H100.
What I've noticed is that everything stays the same from rows 2-51 bu
starting at row 52 and onward the Q and R numbers increment by one.
For example,
H2 = VLOOKUP(G52,Q3:R151,2,1)
H3 = VLOOKUP(G52,Q3:R151,2,1)
H4 = VLOOKUP(G52,Q3:R151,2,1)
...
H51 = VLOOKUP(G52,Q3:R151,2,1)
H52 = VLOOKUP(G52,Q4:R152,2,1)
H53 = VLOOKUP(G52,Q5:R153,2,1)
...
What I need is for every cell in column H to stay the same and not t
increment. I basically need each cell to say what H2-H51 says.
Thanks again for your help
I've got a column of data that has the following formula in each cell:
=VLOOKUP(G52,Q3:R151,2,1)
I initially put this formula in the H2 cell and then copied it dow
through H100.
What I've noticed is that everything stays the same from rows 2-51 bu
starting at row 52 and onward the Q and R numbers increment by one.
For example,
H2 = VLOOKUP(G52,Q3:R151,2,1)
H3 = VLOOKUP(G52,Q3:R151,2,1)
H4 = VLOOKUP(G52,Q3:R151,2,1)
...
H51 = VLOOKUP(G52,Q3:R151,2,1)
H52 = VLOOKUP(G52,Q4:R152,2,1)
H53 = VLOOKUP(G52,Q5:R153,2,1)
...
What I need is for every cell in column H to stay the same and not t
increment. I basically need each cell to say what H2-H51 says.
Thanks again for your help