[SOLVED] vlookup help

[scott]

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

[Casey]

Could you post your formula. It probably holds the clue to why your getting a ref error.

[Peo Sjoblom]

I would avoid that if I were you, but if this is what you mean?

=VLOOKUP(F2:F1001,A2:B50000,2,0)

then you need to select 1000 cells, then enter the formula with ctrl + shift
& enter

it is better to use the first lookup value (in this case F2) then copy down
1000 rows

=VLOOKUP(F2:F6,$A$2:$B$50000,2,0)

(note the absolute reference to the table)

since you can change a single formula whereas if you use the array version
you can't change only a part of it


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"scott" <[email protected]> wrote in message
news:[email protected]...
>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

[scott]

Thanks alot for your help!

Sincerely,
Scott

"Peo Sjoblom" wrote:

> I would avoid that if I were you, but if this is what you mean?
>
> =VLOOKUP(F2:F1001,A2:B50000,2,0)
>
> then you need to select 1000 cells, then enter the formula with ctrl + shift
> & enter
>
> it is better to use the first lookup value (in this case F2) then copy down
> 1000 rows
>
> =VLOOKUP(F2:F6,$A$2:$B$50000,2,0)
>
> (note the absolute reference to the table)
>
> since you can change a single formula whereas if you use the array version
> you can't change only a part of it
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> http://nwexcelsolutions.com
>
>
> "scott" <[email protected]> wrote in message
> news:[email protected]...
> >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
>
>
>