Comparing colums in multiple spread sheets...
Closed
raod720
Posts
5
Registration date
Sunday October 31, 2010
Status
Member
Last seen
November 7, 2010
-
Oct 31, 2010 at 05:24 AM
raod720 Posts 5 Registration date Sunday October 31, 2010 Status Member Last seen November 7, 2010 - Oct 31, 2010 at 09:03 PM
raod720 Posts 5 Registration date Sunday October 31, 2010 Status Member Last seen November 7, 2010 - Oct 31, 2010 at 09:03 PM
Related:
- Comparing colums in multiple spread sheets...
- Sheets right to left - Guide
- How to lasso multiple objects in photoshop - Guide
- Allow multiple downloads chrome - Guide
- How to delete multiple files on mac - Guide
- Mark sheet in excel - Guide
2 responses
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
26
Oct 31, 2010 at 06:29 PM
Oct 31, 2010 at 06:29 PM
Kindly help me with this by giving me hint on what you actually need done? Can't figure out the logic from your example.
raod720
Posts
5
Registration date
Sunday October 31, 2010
Status
Member
Last seen
November 7, 2010
Oct 31, 2010 at 09:03 PM
Oct 31, 2010 at 09:03 PM
Kindly see the explanation.
Sheet1 would be the main data sheet with only one column.
First sheet1 column should compare with sheet2 and if it find any matchings it should present the entire row of the sheet2 in output sheet which is sheet4. Then it should go sheet3 again if any matchings are found(with respect to sheet1) it should pull the data of entire row of sheet3 to place the data in sheet4.
Kindly help me out with this. Your help is really appreciative.
ASAP plz.
Sheet1 would be the main data sheet with only one column.
First sheet1 column should compare with sheet2 and if it find any matchings it should present the entire row of the sheet2 in output sheet which is sheet4. Then it should go sheet3 again if any matchings are found(with respect to sheet1) it should pull the data of entire row of sheet3 to place the data in sheet4.
Kindly help me out with this. Your help is really appreciative.
ASAP plz.