compare and sort random data between different sheets Closed

Question

Hello, 

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..  

Configuration: Windows 7 / Chrome 34.0.1847.131

ac3mark · Answer

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!

Compare and sort random data between different sheets

1 response

Similar discussions

Subscribe To Our Newsletter!