Ask Your Question

Matching multiple cells and printing info to a cell based on the matching.

asked 2015-07-18 16:22:53 +0200

Lassegund gravatar image

updated 2015-07-18 22:16:22 +0200

karolus gravatar image


I am currently in the process of making a spreadsheet that will rank our sellers sales numbers for the month and I have run into some issues. What I have is a list of sellers, with the item they sold and the number of items sold. Seller ID is in Column A, itemcode is in column B and amount sold is in Column C. This is not sorted in any particular way and each seller appears multiple times. (Once for each item sold) What i want to do is create a formula that will search for a seller then find the products that seller sold and then display the total number for each item. For example:

      **Seller      Item       Qty**

         Seller 1    Laptop     1
         Seller 2    Laptop     1
         Seller 3    Phone      1
         Seller 4    TV         1
         Seller 1    Laptop     2
         Seller 3    Phone      1
         Seller 2    Laptop     1
         Seller 1    TV         1

Result in output:

                            Laptop     Phone      TV
            Seller 1          3          0         1
            Seller 2          2          0         0
            Seller 3          0          2         0
            Seller 4          0          0         1

I have tried playing around with INDEX and VLOOKUP, but I have not had any luck. How can i solve this?

Thanks in advance.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-07-18 19:03:45 +0200

karolus gravatar image


goto →Data→Pivottable....
drag and drop Seller into row-field
drag and drop Item into Column-field
drag and drop qty into Data-field
hit ok

edit flag offensive delete link more


That worked perfectly, thanks!

Lassegund gravatar imageLassegund ( 2015-07-18 20:06:33 +0200 )edit

@Lassegund If it worked perfectly, you really should click the check mark to show this is an answer.

JKEngineer gravatar imageJKEngineer ( 2015-07-18 23:50:51 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-07-18 16:22:53 +0200

Seen: 96 times

Last updated: Jul 18 '15