I am new to this forum and it is my first time posting. I hope I'm in the right place.
I have 2 worksheets containing several columns with numerous rows of data.
I have attached a sample of the data. I need to have excel search for the value in cell C3 sheet 2 in column C on sheet 1. If there are no matches then return the text in cell b3 sheet 2 on sheet 3 column b3.
I need excel to compare all the values in column c sheet 2 against the valules in column c sheet 1 and give the differences in column b sheet 3 as described above.
I have tried several different ways to do this within Excel but have not been able to do it. I do not know much about VBS so I need some help.
Can this be done without using VBS? If not what would the formula in VBS be?
Thanks
Sorry for posting this here. I got here by searching and did not notice that questions were not supposed to be posted here. I don't know how to change threads.