Thread: Match/Indexing an array of references

I've got the following problem that I can't seem to get around with match/index. I want to generate an array of values that stores the quantity of a particular equipment item (column N) times the particular price for that piece of equipment. However, since I am running this for multiple customers, there are MULTIPLE equipment matches, so a standard match function only returns the index of the first matched equipment piece. Here's a visual of the situation.
Other Sheet
N (Quantity) M(Equipment Type) (Price)

A:B
1 Alarm Alarm:$5
2 Window Window:$6
1 Motion Motion$8
1 Window D/P: $12
3 Motion
1 Door Panel
1 Alarm
1 Window


Here's the formula I'm using...

=sum(($N:$N)*(INDEX(pricing!$A$1:$B$252,MATCH('Customer Equipment List'!$M:$M,pricing!$A$1:$A$252,0),2)))

The problem lies in the $M:$M and $A$1:$A$252 part of the formula. What I want is for the match function (or whatever I end up using) to go down the M column cell by cell. For each M cell, I want the function to search the entire A1:A252 range.

In effect, I need M to be "variable" as the function moves down the column and A to be "constant," just like MATCH does. Yet I need something that returns an ARRAYof index references that index (or some other function) can process. Any ideas? I know I can use multiple columns to temporary store an array of match/index functions, but i'm trying to do this all in one formula. Thanks in advance.



EDIT: The formatting for the example didn't come out as planned, but assume the first column of numbers is the quantity, the second column (text) is equipment, and the third column (a:b) is the unit price for each kind of item (listed in another sheet)