Look up problem

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

Hi

Is it possible to have a look up function that checks against columns A & B
and returns the value in the C. The combiation of Columns A & B is the only
way I can identify a unique record.
I appreciate I could concatenate columns A & B however that would cause
problems elswhere.

thanks
Pete
 
The answer seems to be to use SUMPRODUCT

=SUMPRODUCT(--(AND([columnA]=[recordA],[ColumnB]=[RecordB])),[ColumnC])
 
Perhaps this sumproduct function will help. To sum c if conditions in a & b
satisfied. To count just leave of the c part but leave the second )

=sumproduct((a2:a200="yourtext")*(b2:b200=12345)*c2:c200)
 
Back
Top