Unanswered: Looking to reference data from sheet in a workbook to another
Within a Workbook I have two worksheets. On the first worksheet I have a list of companies and the states from which they reside. On the second worksheet I have a cell that contains a state. What I am looking to do is when a certain state is entered into the state cell on the second worksheet have it reference worksheet one and give me a listing of matching companies that go to that state. Can this be done using an array function or if not how could it be done?