Hello,
I am working on a worksheet and am trying to find a solution to minimize that amount of work that is involved for using it.
Within my workbook, I have 3 seperate sheets:
Master Completed
Master List
Master Outstanding
Master Completed lists a bunch of store numbers under one heading and also has certain resources (i.e VP and DM) listed under different headings.
Master Store List contains a full and complete list of all stores - including their number, address, VP and DM listings.
Master Outstanding is a sheet that is Master Store List minus the stores listed on Master Completed.
I have a few questions:
1) What is the approiate way to setup Master Completed so it retrieves the store data for me from Master Store List once I enter in the store number?
2) How would I setup Master Outstanding to show the list of stores that are still outstanding (i.e. not part of Master Completed)?
I have been playing around with VLOOKUP for a bit, and keep getting a REF error. The formula I have been using to try and get data from Master Store List for Master Completed is =VLOOKUP(A6,'Master Store List'!A:A,11,FALSE).
Any help that anyone could provide me would be greatly appreciated!
Thanks
Chris
Bookmarks