Compare and sort random data between different sheets

jhanviathaker Posts 1 Registration date Wednesday May 7, 2014 Status Member Last seen May 7, 2014 - May 7, 2014 at 05:07 PM
 Blocked Profile - May 7, 2014 at 05:16 PM

In one sheet I have 200 Names and their phone numbers ( in 2 columns) .

In the 2nd sheet, I have 100 names ( those belong to original 200 names in 1st sheet, but are in a RANDOM order )..

In the 2nd sheet, i need to look up for phone number from 1st sheet for the corresponding name and place it on the column next to the name on 2nd sheet

how can I do that.. Thank you..


1 response

Blocked Profile
May 7, 2014 at 05:16 PM
Have you tried the built in function of filter? You can filter the columns by data drop down. See if that helps.

You could possibly sort, also. Both are built in ready to use actions, no programming required. What you are asking is a Macro, and not easy to deploy if you are not familiar with them!