Macro for searching a list

[Jhansen5452]

I need a macro for searching a list for a multiple keywords within a column. Returning the value from the same row in a different column. This is a monthly parts scrapped list and need it to keep a running total of costs based upon dept. it was charged to. Each month is on a seperate sheet in a table that is auto filtered.