| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to add conditions to Match function? | Excel Discussion (Misc queries) | |||
| lookup with INDEX MATCH formule depending on 2 conditions | Excel Worksheet Functions | |||
| Summing a range with conditions | Excel Worksheet Functions | |||
| Summing a range with conditions | Excel Worksheet Functions | |||
| How do I sum numbers that match two conditions? | Excel Worksheet Functions | |||
Linear Mode
