View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default Match 2 Conditions then Avg Range

Excel2003 ... Oh "Yes" ... Back at it again ... The Long Story ... I have 2
Values on Sheet2 that I wish to locate on Sheet1 ... when found ... Return
AVERAGE value of Cols H:J Sheet1

Sheet2 ... Cell H3 ... I wish Formula (I can copy down) to:

Match value in Cols B:C (Sheet2)
with value in Cols B:C (Sheet1)
Return AVERAGE Cols H:J (Sheet1)

Note: All Values presently formatted Type 1 ...

My "Thanks" to ALL that support this Board ... Kha