creating a formul

I don't understand the advantage to using an array formula in this
particular case.

Can anyone please explain to me the difference between:

=VLOOKUP(A1,$B$1:$C$10,2,0)
(Regular <Enter> - drag down to copy)
AND
=VLOOKUP($A$1:$A$10,$B$1:$C$10,2,0)
Array entered, <C,S,E>, where you have to first pre-select the rows, and
enter the formula in the top focus cell?

Am I missing something?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Myrna Larson" <anonymous@discussions.microsoft.com> wrote in message
news:h7gf11ht9sv2thto7dt6gmqp5go7o9l8m3@4ax.com...
> This is an array formula (since the 1st argument to VLOOKUP is not a
single
> cell, but 10 cells). I would also change the references to absolute, i.e.
>
> =VLOOKUP($A$1:$A$10,$B$1:$C$10,2,0)
>
> Then, to use this, select the 10 cells, E1:E10, and enter the above
formula in
> E1, and press CTRL+SHIFT+ENTER to enter it as an array formula into all 10
> cells.
>
> Note that you don't enter it in the top and copy it down. That would just
keep
> returning the 1st result rather than all 10.
>
>
> On Sat, 19 Feb 2005 14:25:02 -0800, George A. Yorks
> <gyorks@comcast.net.(donotspam)> wrote:
>
> >Thank you for all the help. I am experiencing one little problem. I
write
> >the formula into cell E1 and attempt to copy down to the last cell using
the
> >fill handle. I seems as though every second cell comes up with #N/A.
Any
> >ideas what is causing this.
> >
> >Again thank you for all the help
> >
> >"James" wrote:
> >
> >> You will need to use the vlookup formula. Have a look at
> >> this in the help menu. It's quite simple, and compares to
> >> lists to return a value.
> >>
> >> =vlookup(a1:a10,B1:c10,2,false)
> >>
> >> In this case, it looks up the values in cells a1 to a10
> >> and compares them to the values in cells b1 to b10 and
> >> returns the second value to thr right of these cells;
> >> that is, the values in column c.
> >>
> >> Hope that helps.
> >>
> >> >-----Original Message-----
> >> >Trying to create a formula to do the following:
> >> >Sheet 1 column A a list of personal names a1-a10
> >> >
> >> >Sheet 2 has list of names a1-a10 and list of dollar
> >> amounts colums d1-d10
> >> >
> >> >want to search sheet one and if any name from sheet 2
> >> found on sheet 1 than
> >> >the corresponding dollar amount is entered.
> >> >
> >> >Any help appreciated.
> >> >--
> >> >George
> >> >.
> >> >
> >>
>

I'm not sure there is any advantage. My reply was targeted at the formula he
says he found in Help, in which the first argument was not a single cell, but
A1:A10. I haven't looked at it myself. Maybe he didn't understand the example
in Help and created the formula incorrectly.


On Sat, 19 Feb 2005 16:12:51 -0800, "Ragdyer" <RagDyer@cutoutmsn.com> wrote:

>I don't understand the advantage to using an array formula in this
>particular case.
>
>Can anyone please explain to me the difference between:
>
>=VLOOKUP(A1,$B$1:$C$10,2,0)
>(Regular <Enter> - drag down to copy)
>AND
>=VLOOKUP($A$1:$A$10,$B$1:$C$10,2,0)
>Array entered, <C,S,E>, where you have to first pre-select the rows, and
>enter the formula in the top focus cell?
>
>Am I missing something?