Hi all,
i am trying to crease an automatically updating workboard for work. i have a fiarly good idea how i want the foramt but i am just struggling puting it into practice. i would like to seach an a column for a name and then display data from cells below. The problem is that this data cannot be fixed, the location of the name will change daily depending on where the men areworking.

So i want able to search column A for names, by typing (For example keith) in C3, and in D3 it display information from 2 cells below wherever keith appearing in Column A.

i would like to add a picture for reference to my worksheet but im also new t the forum and not sure how i would do it.

Thanks in advance!