View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Edinburgh Edinburgh is offline
external usenet poster
 
Posts: 3
Default Excel formula - looks up two values?

Hello!

I need to write a formula that allows me to look up two values in a series
of vertical lists and then returns a total value (sumif) from the same table
array that statisfies both criteria.

Something like a vlookup and an AND and a SUMIF althogether if there is such
a beast?

Thanks