I've spent hours trying to figure this out as a mostly beginner excel user.
I have a list of job codes in column A on sheet one. They are alpha numeric such as MGM1234. In sheet two I have a list of 50 special job codes, in the same format, and I am tying to use a V look up in column I of sheet one to tell me which job codes appear in sheet 2 with a yes or no.
I've tried many options found here and elsewhere online and it's only returning a NO.
The job codes were originally stores as general, I tried text and numbers also. I'm suspecting it has to do with either the alphanumeric mix maybe?
Any help is appreciated.
I have a list of job codes in column A on sheet one. They are alpha numeric such as MGM1234. In sheet two I have a list of 50 special job codes, in the same format, and I am tying to use a V look up in column I of sheet one to tell me which job codes appear in sheet 2 with a yes or no.
I've tried many options found here and elsewhere online and it's only returning a NO.
The job codes were originally stores as general, I tried text and numbers also. I'm suspecting it has to do with either the alphanumeric mix maybe?
Any help is appreciated.