cyardley

asked on

# Compare values in 2 columns and populate another column with the results

Hello Everyone,

I have an excel spreadsheet that I need to compare two columns of text to find values that match then populate another column with the results.

My first column (A) has 94,000 rows of data. I have to compare that to my second column (J) that has about 30,000 rows. For values that match I have to populate another column (B) with a "yes" if there is a match.

Is there a macro that can do this for me?

I have an excel spreadsheet that I need to compare two columns of text to find values that match then populate another column with the results.

My first column (A) has 94,000 rows of data. I have to compare that to my second column (J) that has about 30,000 rows. For values that match I have to populate another column (B) with a "yes" if there is a match.

Is there a macro that can do this for me?

the vlookup simply attempts to determine if the value in column A is contained (exactly) within the list in column B

Use this formula on column C if you data is on columns A and B:

=IF(ISNA(VLOOKUP(B1;A:A,1,FALSE)),"","Yes")

jppinto

=IF(ISNA(VLOOKUP(B1;A:A,1,

jppinto

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

To re-iterate, this is confirming that the value in column is listed in column J, correct?

--->>>>> shoudl have been

To re-iterate, this is confirming that the value in

--->>>>> shoudl have been

To re-iterate, this is confirming that the value in

**column A**is listed in column J, correct?ASKER

Thank You Runrigger! I should have realized that a vlookup would have worked.

Did you at least looked at my posts??!

jppinto, I believe that your lookup was the wrong way around!

You're right... :) I missed that! LOLOL

ASKER

Hi jppinto,

I did and runrigger is correct it was the wrong way around. I think I may have caused that confusion with my wording. I really do appreciate your quick response and value this site and all of the people on here that have helped me. Again my apologies if there was any confusion.

I did and runrigger is correct it was the wrong way around. I think I may have caused that confusion with my wording. I really do appreciate your quick response and value this site and all of the people on here that have helped me. Again my apologies if there was any confusion.

No problem...I misread the question. Maybe next time... :)

alternative if 2 lists;

if(iserror(vlookup(a1,$b$1