Extract info from Excel
Closed
Amanda
-
Jan 31, 2011 at 02:08 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 3, 2011 at 09:01 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 3, 2011 at 09:01 AM
Hello, I wonder if you could please help me.
I thought this would be something simple but after an exhaustive search and using filters and Vllookup I have been unsuccessful making this work, I'm hoping this will be something you can help with.
I have 2 excel workbooks, one contains a master list of 1000+ stores with store numbers and addresses, the second contains 200 some store numbers the customer would like to ship to (no addresses). Is there a way to have excel pull the info. from the master list using the 200+ store numbers in the list they want to ship to?
I thank you in advance for any help you can give me,
Respectfully,
Amanda
I thought this would be something simple but after an exhaustive search and using filters and Vllookup I have been unsuccessful making this work, I'm hoping this will be something you can help with.
I have 2 excel workbooks, one contains a master list of 1000+ stores with store numbers and addresses, the second contains 200 some store numbers the customer would like to ship to (no addresses). Is there a way to have excel pull the info. from the master list using the 200+ store numbers in the list they want to ship to?
I thank you in advance for any help you can give me,
Respectfully,
Amanda
Related:
- Extract info from Excel
- Excel mod apk for pc - Download - Spreadsheets
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Crystal disk info - Download - Diagnosis and monitoring
- Number to words in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Feb 3, 2011 at 09:01 AM
Feb 3, 2011 at 09:01 AM
Hi Amanda,
It will be easier to advise you if you give an example of how your sheets look like.
Could you paste like 5 rows of both sheets?
Seems to me like Vlookup would do the job. Just keep in mind that the value you want to lookup must be the left-most value of the matrix.
Best regards,
Trowa
It will be easier to advise you if you give an example of how your sheets look like.
Could you paste like 5 rows of both sheets?
Seems to me like Vlookup would do the job. Just keep in mind that the value you want to lookup must be the left-most value of the matrix.
Best regards,
Trowa
