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?