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?