complex vlookup search

K

keith0628

I have a seven column matrix that I'm trying to return a value afte
checking the values of the first six columns. I figure I have to nes
vlookup statements, but I don't have a clue how to
 
A

Andy B

Hi

One way is to use SUMPRODUCT:
=SUMPRODUCT((A2:A1000="ab")*(B2:B1000="zx")*(C . . . .)*(D. . . .)*(E . .
..)*(F . . .)*(G2:G1000))
A couple of points about this function. You cannot use full columns as
ranges (A:A) and each range in each set of brackets must cover the same
number of cells.
 
Top