View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
MeatLightning MeatLightning is offline
external usenet poster
 
Posts: 27
Default Identify condition using multiple criteria WITHOUT sumproduct?

Cool. Thanks! Really appreciate the help.

This issue I'm trying to solve is actually a small part of a much bigger
system... lots of workbooks with inter-dependencies, etc... so I'm worried
that flipping to a pivot table approach will force a re-write of the whole
thing.... which I'd like to avoid if at all possible.