compare Two Tables - A and B - and Return the Values of Table A

Hi

This is my second post on the same matter.
I need to compare the values of two tables and return the values of table A. However, some identifiers in table A repeats twice or more.
On my first post, Sambo Kid provided the formula =IFERROR(VLOOKUP($F2,$A:$D,COLUMN(B$1),FALSE),""), which partially worked, because the second instance where the identifier repeats the formula doesn't return its second instance.
A copy of the spreadsheet is attached.
Thank you for the help again.

Attach the file directly here, please.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

VLOOKUP is designed only to return the first matching value it finds.

Yes, it does. Don't try to use the paperclip icon - follow my instructions.

Thanks!

I don't understand the data - is this a before and after? I can't see the formula anywhere.

Originally Posted by AliGW

VLOOKUP is designed only to return the first matching value it finds.

I thought the same thing about VLOOKUP, too.

Yes, but where should I apply it? You have not yet properly explained the two datasets in the attachment. Remember you know what it all means and how it relates - I don't (yet).

Hi Ali

As I said I applied the formula to the spreadsheet.
I want the stock level figures in column B of Table A to be returned according to the Code. However, in Table A, the code sometimes repeats twice, hence only the first instance of the code that repeats is being returned, rather than the sum of the stock level of the code that repeats twice.

Also, the stock level figure is supposed to be placed in the same row as the matching code of Table B.

Please let me know if you have any doubt.

Thank you.

Sorry - I have been busy working and not yet had the opportunity to have a look. I'll have a quick look now.

I think this is what you need:

=IFERROR(SUMIF($A$3:$A$134,F3,$B$3:$B$134),"")

Glad to have helped!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Kind of you - thanks. Not really that impressive - SUMIF and SUMIFS are pretty run-of-the-mill. You might want to read up on COUNTIF/COUNTIFS and as you have 365, AVERAGEIF/AVERAGEIFS as well. All very handy!