Alternatively, you can just double click on the fill handle to copy the
function to all the cells in the column at once.


"T. Valko" wrote in message
...
"Grab" the fill handle with the left mouse button and then drag down the
column. The fill handle is the little black square on the bottom right of
the selected cell. When you do a mouse-over of the fill handle the cursor
will change from a "fat" plus sign to a "skinny" plus sign.

Make the row references to your lookup table absolute:

=VLOOKUP(A1,J$1:K$100,2,0)

Biff

"ChrisB" wrote in message
ups.com...
Ive found out how to work it, but I keep on having to hit CTRL + V to
paste the formula all the way down!!! is there anyway around this ?



ChrisB wrote:
if I copy the formula down the column, am I going to have to change my
lookup value for each cell?

T. Valko wrote:
One cell at a time, but, you can copy the formula down the column.

Biff

"ChrisB" wrote in message
oups.com...
can I set my VLOOKUP function to automate through an entire column?
or
will it only do one cell at a time?