SOLVED

Match data

Copper Contributor

Hello! Hope you can help me with this:

I have two databases, in the first one Names, ids, emails of all the people in the big group, in the other one just some of them just with the name and id. How do I do to get from the first one the e mails of the people in the second one without searching one by one?

2 Replies
best response confirmed by Grahmfs13 (Microsoft)
Solution

@PilarTorija 

You can probably use the VLOOKUP or XLOOKUP function for this. Could you provide more details? Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Thanks a bunch Hans!
I've found a video showing VLOOKUP and it's exactly what I needed.
Thanks again!
1 best response

Accepted Solutions
best response confirmed by Grahmfs13 (Microsoft)
Solution

@PilarTorija 

You can probably use the VLOOKUP or XLOOKUP function for this. Could you provide more details? Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

View solution in original post