Search for corresponding mobile phone number using email address

Hello and welcome to the forum,

You can use a formula (vlookup or index/match) in FileB or use a macro to do it for you. In both cases, we need to see dummy copies of your data to properly help you. Keep the structure the same, but you can replace the real data with false data.

[SOLVED] Yes, thank you user abousetta and san2525.
I did a search online and found http://www.timeatlas.com/5_minute_ti...ookup_in_excel
that is very good for beginner like me.

Works like a charm! Thank you!

Originally Posted by davisraye

Hi,

I have an excel file with member details such as NAME, EMAIL and MOBILEPHONE NUMBER. This excel file FileA.xlsx has about 3000 records/rows.

I have another excel file FileB.xlsx which contains only some of the email addresses listed in FileA.xlsx - about 400 email addresses only.

How can I write a script or macros to retrieve the corresponding 400 MOBILEPHONE NUMBERs from FileA.xlsx and list them besides the email addresses in FileB.xlsx. So I will have one column email address, next column their mobilephone number.

Yes, I was really happy when I learned how to use vlookup for the first time. It was like magic.

Good luck.