lookup a list of values for an array formula
 

I wanted to know if there ia a forumla lthat can
Take data in Cloumn Mrow 5 in Spreadsheet 1 ,and comapre that to spreadsheet
2 column G and return the corresponding value in Ion spreadsheet 2, then
Using the data in Column C it would need to look at colum Hon spreadsheet 3
and summing up all items in column b on spreadsheet 3.
I think that this is an array. Best that I could do is to get only one item
to sum.

SUM(IF((IF($M$50,RIGHT(Exposure!$H$2:$H$15000,3)= RIGHT(INDEX(SBU_MU_Codes!$G$1:$I$15000,IF(SBU_MU_C odes!$G$1:$I$15000=$M$5,ROW(SBU_MU_Codes!$G$1:$I$1 5000)),ROW(7:7)),3),"
"))*(Exposure!$Q$2:$Q$15000<0)*(Exposure!$A$2:$A$1 50000)*((Exposure!$A$2:$A$15000
- Exposure!$C$2:$C$15000)<=30)*((Exposure!$A$2:$A$15 000 -
Exposure!$C$2:$C$15000)=0),Exposure!$Q$2:$Q$15000 ))