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