Hi
I am trying to make my life easier at work using excel, and there is one thing I need help with.
Here is the case:
I got 2 spreadsheets, lets call them A & B.
In spreadsheet A I have thousands of lines with information, where each line has 8 columns.
The first column of each line has a case number (which I am interested in), followed by different kinds of information.
I get contacted by a company, giving me spreadsheet B, containing 50 case numbers (which are not sorted in any order)
I need to find each case number from spreadsheet A, and get all that information into spreadsheet B. (Right now, I copy each line seperately, and it takes a lot of time)
Is there a way that I can get Excel to give me the 50 case numbers from spreadsheet A, and transfer all the information (all 8 columns) over to spreadsheet B? (is the a formula that makes Excel search a column in spreadsheet A for all the case numbers in spreadsheet B, and if it finds a match, it will copy the information in all 8 columns over to spreadsheet B)
If you could help me with this, I would save hours of work every week =)
I am trying to make my life easier at work using excel, and there is one thing I need help with.
Here is the case:
I got 2 spreadsheets, lets call them A & B.
In spreadsheet A I have thousands of lines with information, where each line has 8 columns.
The first column of each line has a case number (which I am interested in), followed by different kinds of information.
I get contacted by a company, giving me spreadsheet B, containing 50 case numbers (which are not sorted in any order)
I need to find each case number from spreadsheet A, and get all that information into spreadsheet B. (Right now, I copy each line seperately, and it takes a lot of time)
Is there a way that I can get Excel to give me the 50 case numbers from spreadsheet A, and transfer all the information (all 8 columns) over to spreadsheet B? (is the a formula that makes Excel search a column in spreadsheet A for all the case numbers in spreadsheet B, and if it finds a match, it will copy the information in all 8 columns over to spreadsheet B)
If you could help me with this, I would save hours of work every week =)