i have a spreadsheet with two drop down boxes and I need a way of searching 10 other sheets to find a result based on the selection made in the front sheet.
so for example:
A1 = Date
B1 = Primary contact
D1 needs to equal TEAM A Primary Contact
E1 needs to equal TEAM B Primary Contact and so on for all 10 sheets
Can anyone help please
Bookmarks