Need help on Excel Please

%3CLINGO-SUB%20id%3D%22lingo-sub-1865777%22%20slang%3D%22en-US%22%3ENeed%20help%20on%20Excel%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1865777%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Please%20can%20someone%20assist.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20Sheet%201%20two%20columns%2C%20A%20is%20a%20list%20of%20items%2C%20B%20is%20the%20category%20for%20each%20item.%26nbsp%3B%20In%20C%20I%20would%20like%20to%20do%20a%20formula%20to%20check%20column%20A%20with%20Column%20A%20on%20Sheet%202%20and%20if%20it%20is%20a%20match%20then%20add%20the%20value%20of%20Sheet1%20Column%20B%20here.%26nbsp%3B%20I%20just%20cant%20seem%20to%20get%20this%20right%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20can%20someone%20assist.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1865777%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hi Please can someone assist.

 

I have Sheet 1 two columns, A is a list of items, B is the category for each item.  In C I would like to do a formula to check column A with Column A on Sheet 2 and if it is a match then add the value of Sheet1 Column B here.  I just cant seem to get this right?

 

Please can someone assist.

 

Thanks,

 

 

1 Reply
Highlighted

@Chany5 

Use SUMIFS() or a pivot table.