I'm struggling with something that is seemling easy (also could not find it in any previous posts)...
I'm trying to do a variation of a lookup/match where I have information on two worksheets:
Sheet 1: has a list of values C3:C1002
Sheet 2: has a different list of values C6:C319
I would like to show the overlap of the two lists on the third worksheet in the in column C.
Any suggestions would be greatly appreciated. Thanks in advance for your help.
Erik
I'm trying to do a variation of a lookup/match where I have information on two worksheets:
Sheet 1: has a list of values C3:C1002
Sheet 2: has a different list of values C6:C319
I would like to show the overlap of the two lists on the third worksheet in the in column C.
Any suggestions would be greatly appreciated. Thanks in advance for your help.
Erik