Matching

[Guest]

Hi,
I need the new table to fill in automatically from the
another table.

A B C
1 FRUIT COLOR AMOUNT
2 apple green 100
3 apple green 150
4 orange yellow 100
5 orange yellow 200
6 apple red 175

E F G
1 FRUIT COLOR TOTAL AMOUNT
2 apple green 250
3 orange yellow 300
4 apple red 175

As I used VLOOKUP for col G but need your help on col E
and F, which could auto fill in from A and B and without
repeating.

Thank you!

 

[Debra Dalgleish]

To summarize the data, you could build a pivot table from the first
table, with Fruit and Colour in the row area, and Amount in the data area.

There are instructions and links for pivot tables on Jon Peltier's site:

http://peltiertech.com/Excel/Pivots/pivotstart.htm