You can grab the corner of the cell with the mouse and copy it down or
select a large range with the formula in the top cell
and press Ctrl + d


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"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?