Retrieve values based on two condition

**roshankp** · 08-10-2010, 05:04 AM

Need to retrieve the values based on two conditions.
Go through the attachmnet and help me out to achieve with the help of function.
MAcros Shouldnt be useddd...

Thnx in adv

**zbor** · 08-10-2010, 05:09 AM

Here, try a Pivot table:

**Richard Buttrey** · 08-10-2010, 05:12 AM

Hi,

For one solution see attached.

Rgds

**contaminated** · 08-10-2010, 05:13 AM

There too many options to do that. These formulas ca help you. In I27

=INDEX($C$6:$C$26,MATCH(1,INDEX(($H27=$A$6:$A$26)*(I$26=$B$6:$B$26),0),0))

Copied down the across the matrix..