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" wrote in message
...
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
.(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
.
|