Need help on Excel Please

Copper Contributor

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

@Chany5 

Use SUMIFS() or a pivot table.