Yes, my statement was incorrect. Thanks Alan!
While VLOOKUP does accept an array of lookup values, it doesn't seem to
pass that array to a subsequent function, as in the following...
{=MIN(VLOOKUP(A1:A3,A1:B8,2,0))}
In article ,
Alan Beban wrote:
Domenic wrote:
Unfortunately, VLOOKUP does not accept an array of lookup values.
??
=VLOOKUP(a1:a3,a1:b8,2,0) array entered in a 3-cell column returns the
values from Column B corresponding to the values in A1:A3.
Alan Beban
|