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