V Lookup
 

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

Thanks a bunch!
rojobrown

V Lookup
 

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)

"rojobrown" wrote:

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

Thanks a bunch!
rojobrown

V Lookup
 

That's exactly what I needed....

--
Thanks a bunch!
rojobrown


"rojobrown" wrote:

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

Thanks a bunch!
rojobrown