I have a table (ContactList) with my contact (Tab1). In cell B2 I can manually enter or select from the dropdown list. This return the individuals information in cells B3-B9. On the Dept Contact List worksheet, in cell B2, I would like to be able to select a Dept and have all the member of that dept to be listed with the desired info. I have attempted to INDEX MATCH but can only capture just one record and I suspect that the solution doesn’t need to be complicated.
Any help is greatly appreciated
Jaycee66
Bookmarks