Previous Topic Next Topic

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
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



Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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
0

Similar discussions

We’re reviewing your info
dilsherxsingh -
Abhishek0025 -

2 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
Facebook says that my email doesn't match my facebook email
@@@@@@@@@@@ -
Ambucias -

1 response