Forum Discussion

Chany5's avatar
Chany5
Copper Contributor
Nov 08, 2020

Need help on Excel Please

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,