Need to match two columns and give 3rd result with multiple results pos for each match

I have a situation where I need to find all matches to a job number from sheet1 column G with sheet2 column Q and display result of column FW. There can be multiple matches and I need to sum the results for each job into one location. This really has me perplexed. Any and all help would be much appreciated.

If you could upload a sample workbook with desensitized data showing what your intended outcome would be, that would be helpful.

Originally Posted by danielexcelvba

If you could upload a sample workbook with desensitized data showing what your intended outcome would be, that would be helpful.

Yes I will work on an example wkbook in the morning when I am able to put something together that fully demonstrates my needs. The book I'm working in has hundreds of columns so I think I can just throw another smaller example together from scratch much faster.

Ok after looking at what I have this is what I think I need to do.

I need to get a sum for all money in column BT by each job on the wpc tab but not include duplicate jobs. this can be searched by matching the column G on the 2017 filtered tab to column Q on the wpc tab. but then looking at column BS for duplicate job numbers and discarding the money in the adjacent column bt. When I get this working im also going to have to look at column BW and do the same thing.