compare list B with list A, return cell data on row where B matched A

Hi - I need a function or at least pointed in the right direction...

List A was made from a MYSQL dump and has 3,000+ entries, in order, via an ascending key generated by the DB when each record was added. (ie., 1,2,3,4 ... 7,390)

List B was made from the same dump but only has 1,000 entries, not in order but uses the same set of keys to match those records to the master table records. (4, 350, 122, 123 ...)

Apparently over time, some records in A were deleted leaving some numbers out of the key sequence (ie., 1,2,4,8,9 ...) - this is why there are only 3,000 records but the key ends at 7,390!

Also the info in table B must have been optional as there are only 1,000 entries - 1/3 of the master list to which it is paired with.


I need a function that will compare the key column in table B to table A and extract data from the corresponding cell in a different column on the same row in table B THEN list it in the correct row / cell in table A. In layman terms, I am trying to match email addresses in table B to the correct contacts in table A and 2/3rd's of the emails were never filled in so the only way to pair them up is by matching the keys.

I know nothing about Excel functions but I've been researching and think this may be a job for =vlookup? or some iteration thereof. Please help!!!

here is the sample as requested ...

sample.xlsx

As you can see the function needs to be smart enough to overlook orphaned data in table-B that doesn't have a matching donor_id key in table-A

Originally Posted by sktneer

In that case you may try this...

Please Login or Register  to view this content.

that is a lot more complicated!

I have not tried it yet. Is 01:00 am where I live. I will try it in the morning when I get in front of my computer again.