...lookup?

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

J.W. Aldridge

Names are in cell e10, j10, o10, t10, y10, ad10.
Numbers are in: G11, L11, Q11, V11,AA11, AF11...

How do i perform a lookup for the name reference in the top row to sum
the values in the bottom row?

In other words, lookup value = x.
Lookup in range "funny" (rows 10 & 11).
Each time "x" is found, return and add the values in the cell down
1row ,2 over to the right.
 
Say you enter your name to find into D10, and try this:

=SUMPRODUCT((MOD(COLUMN(E10:AD10),5)=0)*(E10:AD10=D10)*(MOD(COLUMN(G11:AF11)-2,5)=0)*G11:AF11)
 
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.
 
Try this, with name to lookup entered into say D10:

=SUMPRODUCT((MOD(COLUMN(E10:AD10),5)=0)*(E10:AD10=D10)*(MOD(COLUMN(G11:AF11)-2,5)=0)*G11:AF11)
 
Back
Top