VLOOKUP Function

C

ChrisB

can I set my VLOOKUP function to automate through an entire column? or
will it only do one cell at a time?
 
C

ChrisB

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

ChrisB

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

Peo Sjoblom

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)
 
T

T. Valko

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

Arsenio Oloroso

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