Search for common post codes

Sheet 1. I have a list of customers (A), their revenue (B) and basic post codes (C). Note there may be more than one customer at that postcode (duplicates) (see bold font)

Sheet 2. I have a 2nd shorter list of unique post codes - some will match those in Sheet 1 (I have marked in yellow). I want to compare Sheet 2 column A against Sheet 1 column C in order to work out the total revenue of those common post codes. If the common post codes can be highlighted in some way, I can then filter (perhaps by colour) and then get the total.

Kudos to whoever can solve this
Thank you in advance

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet.