i would like to create one vlookup for a column of cells. is this possible? i
tried by selecting the colum and entering the vlookup, but it only pertained
to the first cell. i tried to enter the formalu, then copy and paste, but it
returns a #REF!

i would like to aviod entering a formula 1000 times.

any ideas?
thanks