Matching entries from separate lists

[forbes61]

I'm not sure if this is the correct place to ask, so if it's not just point me in the direction and delete.



My girlfriend is working on a project for work where she has two lists of information. One is a list of about 1300 entries (call it list A) of information for every independent pharmacy in an entire state and the other is a hand-picked subset (~500 entries) of that list (list B). What she needs to do is match entries in list B to their corresponding entries in list A and then pull the addresses and move them to the correct spot in list B. I believe both are (or can be) excel spreadsheets.

She's sitting here doing it by hand and I think there has to be a better way, I'm just not familiar enough with access to do the manipulation. Is this possible?

[June7]

Why is Excel involved if there is an Access database?

Code to do what you want from Access would be very complicated and really should be unnecessary. Data should not have to be 'moved'.

Access uses queries to create 'subsets'.

Even in Excel, rows can be filtered.

[JeffChr]

if the data is indeed in Excel worksheets then i would point in the direction of the vlookup function in excel to fill in the addresses. it may work depending on what your data looks like.

[forbes61]

Why is Excel involved if there is an Access database?

Code to do what you want from Access would be very complicated and really should be unnecessary. Data should not have to be 'moved'.

Access uses queries to create 'subsets'.

Even in Excel, rows can be filtered.

Yeah, the whole situation was less than optimal for sure. She used google maps and the original list to plot 4 days worth of driving routes for 5 different sales reps for a sales push in their new expansion territory. Then she went along each route and pulled the names of those stores thinking that the reps could look at the distilled route list on the paper and then either use their GPS or cross-reference the big list on their ipad to get the address (if needed). Turns out, her boss wasn't a fan of that and insisted on having the addresses in the route list. So now she had the route list of just names and had to go back and find each individual one in the bigger list. As for this post, I haven't used access except for just very basically in an intro class in highschool. All I really remembered about it was that it had more advanced database manipulation tools so I thought it might be of some use in order to compare lists. Turns out we were able to figure out how to make it work in excel using vlookup.

if the data is indeed in Excel worksheets then i would point in the direction of the vlookup function in excel to fill in the addresses. it may work depending on what your data looks like.

Yep that ended up being just the thing we needed. Thank you. This can be closed.