V Lookup

R

rojobrown

How can I copy a vlookup formula down without the cells changing every row
down?

Thanks a bunch!
rojobrown
 
B

bpeltzer

Presumably you do want the lookup value to change every row (otherwise you'll
get the same answer every time), but not the table array. Change that
portion of the formula to use absolute references rather than relative
references:
=vlookup(a1,$C$20:$E$35,3,false) rather than =vlookup(a1,C20:E35,3,false)
 
Top