#1
|
|||
|
|||
Excel Searching/Sorting Options
I have two different Excel Files each having two different columns of data, they share one common set of data in a Column. I want to copy and paste and create one file, but sort the file so the common data matches and then extract and match the data linked to it. Please let me know if this doesn't make any sense. I think I am over complicating things as I believe this is probably a common problem. Thanks in advance for any solutions.
Shaun |
#2
|
||||
|
||||
Perhaps something like a VLOOKUP function?
Eventually post a small sample showing some data and desired results?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Tags |
columns, data, sorting |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sorting the Outlook inbox before searching for an email | Officer_Bierschnitt | Excel Programming | 2 | 11-25-2015 01:14 AM |
Urgent help needed: Sorting/searching fields | cvrm | Excel | 2 | 04-17-2014 05:47 AM |
searching for text in multiple excel files | roytom | Excel | 2 | 07-30-2012 01:57 PM |
Sorting larg Excel file cause windows hang | tasuooooo | Excel | 1 | 07-17-2012 07:23 AM |
Sorting columns in Excel - please advise | Jonre | Excel | 2 | 08-21-2009 02:38 AM |