Lookup with multiple conditions

[Ecel Dumbo]

Hello Dear Excel friends,


please refer attached spreadsheet. please help me build a formula to look up values using multiple conditions. Thanks heaps


http://speedy.sh/2d3Ba/Multiple-Look-Up-formula.xls


Regards

Excel Dumbo

 

[Faseeh]

Hi E_Dumbo,


Try this:

=OFFSET(INDIRECT("B"&MATCH(A7,$B$22:$B$62,0)+21),MATCH($A$6,INDIRECT("C"&MATCH(A7,$B$22:$B$62,0)+21&":C"&MATCH(A7&" Total",$B$22:$B$62,0)-1+21),0)-1,MATCH($B$1,$D$21:$M$21,0)+1)

Enter in Sheet1, B7 and drag down, adjust cell references to apply to B3 & B4...


or see this file:


http://dl.dropbox.com/u/60644346/Multiple%20Look%20Up%20formula_Solution.xls


Regards,


Faseeh

 

[Ecel Dumbo]

Thanks a lot Faseeh. Works like magic

 

[Faseeh]

You are welcome!


Faseeh