How to find phone number in another page ?
Hello,
Sorry but I'm not a excel developper.
In an Excel file, I have a page with a list of phone number in a column.
In another page in the same excel file, I have a people list with phone number.
How can I find in the first page, the correct people depeding on the phone number stored in the second page ?
Thanks in advance
Kind regards
Nicolas
Try something like:
=Index(Sheet2!A:A,Match(A2,Sheet2!B:B,0))
where A2 has the first phone number to match.
Sheet2 column A has the names to extract and Sheet2 Column B has the phone numbers to match up against.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
also select the cell next to the name and run macro
this corrected code will work
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks