I need help with a problem I have please.
I have two separate sheets A and B.
I am trying to count the number of times a product appears in sheet B and the return this value in a cell in sheet A. sounds simple enough.
However a simple VLookup function is not working because the value that has to return to the cell in sheet A has to match 2 criteria along an X and Y axis.
I am trying to count the number of times the product appears in sheet B relating to a specific placement and bring the value back to Sheet A in the specific cell.
Here is an example of what I mean as the sheet i am working from has thousands of rows:
Sheet A
Product 2 Product 3 Product 4
Placement 1 value? value? value?
Placement 2 value? value? value?
Placement 3 value? value? value?
Sheet B
Placement 3 Product. 5
Placement 2 Product. 3
Placement 1 Product 3
Placement 2 Product. 3
Placement 3 Product 2
Placement 3 Product 2
Placement 1 Product 2
Placement 2 Product 4
Placement 3 Product 4
Any assistance would be very much appreciated.
Thanks,
Adrian
Bookmarks