In E1: =SUMPRODUCT(--(Sheet2!E1:E1000=the_val),--(Sheet2!A1:A1000=A1))

not really sure about the req so it is a bit of a guess.

--
HTH

Bob Phillips

"z.entropic" wrote in message
...
I'm trying to get around the problem of VLOOKUP looking up only the first
found match. Here's and example:

Each row in the first worksheet has a unique value in the first column
(file_ID), and a variable number of the same file_ID entries in
consecutive
row blocks in the second worksheet. Now, I'd like to extract to the first
worksheet the corresponding values in, let's say, column 5 in the second
worksheet IF the column 3 value in that 2nd worksheet meets a certain
condition. The values in column 3 are unique for each file_ID entry.

I couldnt solve the problem with various combinations of VLOOKUP and IF
and
suspect that an array formula would be needed--but I don't know how to
bite
it...

z.entropic