Hi,
I have the following data in a sheet, and I am trying to create an easy to use search box in Excel that can give me the output I need.
The reason I need a search function is that I have more than 50 people doing tasks, and the excel has more than 50 columns. A nice search function would make things much easier.
Input: the tasks (there are no duplicates)
Output 1: Date
Output 2: Person
Is there a nice way to build a search function in Excel, where I can input the name of the task (maybe from a drop-down) and then I get the output 1 and 2 to appear automatically on separate cells?
Thank you!
<tbody>
</tbody>
I have the following data in a sheet, and I am trying to create an easy to use search box in Excel that can give me the output I need.
The reason I need a search function is that I have more than 50 people doing tasks, and the excel has more than 50 columns. A nice search function would make things much easier.
Input: the tasks (there are no duplicates)
Output 1: Date
Output 2: Person
Is there a nice way to build a search function in Excel, where I can input the name of the task (maybe from a drop-down) and then I get the output 1 and 2 to appear automatically on separate cells?
Thank you!
Person 1 | Person 2 | P3 | P4 | P5 | Etc.. |
Date 1 | Date 2 | date 3 | Date 4 | Date 5 | |
Task 1 | Task A | AA | AB | CF | |
Task 2 | Task B | BB | BA | CG | |
Task 3 | Task C | CC | CA | GH | |
Task 4 | D | DA | KL | ||
Task 5 | E | EA | |||
<tbody>
</tbody>