Thread: look up using 2 cells from one sheet to find a value in another...
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim Carim is offline
external usenet poster
  
Posts: 510
Default look up using 2 cells from one sheet to find a value inanother...
Hi,

As usual, sumproduct() will do the job ...

=SUMPRODUCT(--(Sheet2!A2:A6=Sheet1!A2),--(Sheet2!B2:B6=Sheet1!
B2),Sheet2!C2:C6)

HTH
Reply With QuoteReply With Quote