Need to stop VLOOKUP formula changes

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
 
F

Frank Kabel

Hi
use
=VLOOKUP(G52,$Q$3:$R$151,2,1)

Thoug I would assume the following could be what you want:
=VLOOKUP(G52,$Q$3:$R$151,2,0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top