Attention: Please take a moment to consider our terms and conditions before posting.

Options

I am sure the title of this thread won't bring too many people to the discussion - but I need some help from any database-savvy people out there! I don't have much time to work this out...

I have a list. In that list is 950 entries. I have another list, which has about 850 entries. I need to cross-reference the two lists so that I am left with the 100 oddities that my team can then update and fix. As I am not very clever with Excel, and the Google results I am finding aren't cutting it, I'm hoping someone here can help me figure out the (presumably very simple) way this ought to be done!

Boy do I hope this isn't the last post on the thread. Help!

I have a list. In that list is 950 entries. I have another list, which has about 850 entries. I need to cross-reference the two lists so that I am left with the 100 oddities that my team can then update and fix. As I am not very clever with Excel, and the Google results I am finding aren't cutting it, I'm hoping someone here can help me figure out the (presumably very simple) way this ought to be done!

Boy do I hope this isn't the last post on the thread. Help!

0

Powered by Vanilla

## Comments

Then in the one you want to see if it matches. Do...

=vlookup(Key1,LookupList,1,false)

Key1 being your unique key in one of the lists

LookupList being your second list

1 will simply return the first column

False will look for an exact match

When doing the lookup the unique key must be in the first column of your lookup list. ie Everything that could be in B1, B2, B3 etc needs to be in column D.

=vlookup(B1,D:E,1,false)

I find it easier highlighting the whole of the column to save putting $ signs in to lock the cells when you copy the formula all the way down.

p.s Excel is for maths, not for databases