Lookup values in an array

[Chrisgourdine]

Column A:A contains a list of part numbers.
Column B:B contains the part cost.
Column C:C contains a list of part numbers used on a certain project. Sometimes a part number will be listed multiple times.
Cell D1 should display the total cost of all parts listed in column C:C

I am looking for an easy formula for Cell D1 as sometimes there are hundreds of items listed in column C:C.

Thanks for any help you can be.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=SUM(FILTER(B2:B10000,COUNTIFS(C2:C10000,A2:A10000)))

 

[Chrisgourdine]

Thanks Fluff! That works perfect!

 

[Fluff]

You're welcome & thanks for the feedback.