Nov 08 2020 08:27 PM - edited Nov 08 2020 08:29 PM
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,