VLOOKUP with multiple conditions

[Roses8]

Hi,

i have this formula, it however is a sumproduct, but i would like this to be exactly the way it is with the conditions it needs to follow, but it should do be a vlookup. Can this be done?

=SUMPRODUCT(--(Sheet1!$C$2:$C$6766=B7),--(Sheet1!$B$2:$B$6766=$F$7),--(Sheet1!$A$2:$A$6766=$B$1))

I hope you can help.

thanks.

 

[just_jon]

You can use concatenation to glue several key fields into one larger search string, then do a VLOOKUP or INDEX/MATCH on that.

EDIT - an alternative would be an array version of INDEX/MATCH