Hello,
I have 2 separate sheets of Data. One of the sheets has every store number 1 - 2000. The other sheet only has 1500 stores and the numbers are {3,4,7,11,12,16,17 etc}
In the sheet with all of the stores, it has the address of each location. The second list only has the store number. The second list is the list of stores that need to be serviced and I want to get the addresses moved from the big list to the smaller list.
PLEASE HELP!
Last edited by XLriddler; 11-29-2011 at 02:50 PM. Reason: solved, Thank you very much! both of you!
Try Vlookup.
e.g.
=IFERROR(VLOOKUP(A2,'Sheet1'!A:B,2,FALSE),"")
This looks at store number in A2 of the active sheet, and tries to find it in Sheet1, column A. If found it returns the corresponding item in column B.
The IFERROR() is an error trap to return a blank if match is not found.
copy formula down.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
In the sheet with only the store numbers, use the formula:
=vlookup(A1, Sheet1!$A$1:$B$1500, 2, false)
I am assuming A1 is the second sheet that only has the store number, Sheet1 is the name of first sheet with store numbers and addresses, and A1:B1500 contains the store numbers and cooresponding addresses. This formula will use the store number of your second page and look for it on your first page, then bring back the address. You use the $ signs so that the reference cell value is absolute.
Hope this helps!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks