I am using an array sunction consisting of a SUM( with an IF( to test a
condition on array cells and if the condition is fine I am doing a VLOOKUP(
the first argument of which has an array subtracted from a single cell
constant, and an array for the second argument. My problem is the VLOOKUP
match for the first element of the array is repeated for all the other array
elements. If experimented with different array values to figure this out
Is there a problem with VLOOKUP embedded inside an array function? I
rooted around in the help site & noticed there was a warning about using AND
or OR in array functions because of single value results I've tried an array
function using a MATCH instead of the VLOOKUP with the same arrays and MATCH
returned the correct results. I've also done an array function using the
arguments of the VLOOKUP and they also don't have this "first match" error.