Thread: Multiple VLOOKUP
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
  
Posts: 510
Default Multiple VLOOKUP
Sorry, a typo there!


=SUMPRODUCT(--(Sheet1!A1:$A$1000=322654),--(Sheet1!$B$1:$B$1000="015"),Sheet1!$C$1:$C$1000)

--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


Reply With QuoteReply With Quote