# Compare 1 column with another column and match data in next column

1. ## Compare 1 column with another column and match data in next column

Hi there,

I'm not sure ifor there is a function like this so that's why I'm asking. Is it possible to compare column A with column B and then tale the data in column C, that corresponds with the data in column B, and male it show up in column D? I have some of the same data in column A and B but each column has different
things missing, and the data in column C is part of the data fr column B, so I want to compare column A and B and if it matches then I want it to show the data in column D (column A and B are numbers as they and column C is text because it's a list of names). I hope that this makes sense to somebody as I am not sure what to do, if there isn't a function that helps with this I'm going to have to compare about 750 files individually.

Thanks so much to whomever helps!

2. ## Re: Compare 1 column with another column and match data in next column

if I understand you correctly, let's say you have a value in col A and you have values in col B and corresponding data to B in col C, you can use a vlookup in col D to find what is in A that matches in B and return value C.
So something like =VLOOKUP(A1,B:C,2,FALSE) in col D will return the values from col A and their matches in col B and what is col C. Is that what you want?
Otherwise it might be helpful to post a sample of your data so people can better solve the problem for you.

3. ## Re: Compare 1 column with another column and match data in next column

Thanks for your help, tthis was exactly what I needed, all I had to do was lock the column values and then it worked perfectly!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1