Look UP using multiple conditions

[Ecel Dumbo]

Hi,

I had posted this query in your old forum and was advised it was moved to this new forum. I could not find it. Hence posting again.


please find attached a file where i would like to look up a certain value from a file that is not in order.
any help will be greatly appreciated. i have populated the desired answers
http://speedy.sh/yWF35/Complicated-look-up-with-formula.xls
thanks heaps

 

[Faseeh]

Hi Ecel Dumbo,

Can you verify this Array formula, put in L23 and drag down and right:

=SUM(IF(TRIM(MID($A$10:$A$433,6,99))=$K23,IF(LEFT($B$10:$B$433,3)=M$21,$C$10:$C$433)))/(SUM(IF(TRIM(MID($A$10:$A$433,6,99))=$K23,IF(LEFT($B$10:$B$433,LEN(M$21))=M$21,$D$10:$F$433)))/3)*30

It would be great if you can give results of the second column that is problematic.

Regards,