[Solved] Data Validation : Comparing data from three sourc

• Hello Everyone:

I don’t know if this needs to be done in access or excel…I have three lists of numbers all six digits long. The lists are all various lengths. I would like to compare list one to two and see which numbers are similar in each list. And then I would like to compare list three to one and do the same. And if this is not too complicated I would like to compare list two to three.

If my description is a little vague here is a little more specific explanation. I have three computer applications that are not integrated however they are using the same six digit code. I want to compare the codes in each and see which codes are similar between all three.

I know should be an easy way to do this in either access or excel but I can’t think of it. I have attached a copy of the numbers in case that helps. Thank you in advance.

Cheers,
Jason

• What do you mean by'similar'?

Is 123456 'similar to' 123457 ?

• If you mean identical, then you could use VLOOKUP. I created 3 lists in teh same worksheet for convenience, but the Vlookup arguments can point to other sheets if you want to leave you lists in place.

Columns E:G compare List1 to List2, List 2 to 3, and 1 to 3. Common numbers are displayed, if no match, then #N/A is displayed.