Search data in one Column, display data from lower down the same column.

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!

This should be easy enough to accomplish. Upload a sanitized sample file reflecting your desired outcomes. At the bottom right corner of the message box, click on 'Go Advanced', which is between the 'Post Quick Reply' and 'Cancel' buttons. On the next page at the top of the message box find the icon of a paperclip and click on it. Select the sample file and upload it.

Try

=INDEX(A$3:A$102,MATCH("Keith",A$1:A$100,0))

Notice the 2 row offset of the 2 referenced ranges.

Thanks for thye Reply. I havd done as you instructed and uploaded a small sample of my Worksheet.

what im after is as you update the table on the left information from there is automatically added to the one on the right. as i said before the engeneers names will not be static, they will move around so i need a formula that
will search colum A and then input the data below it into the table on the right. ie, the site where kieth is working is minworth so as keith is added to the board on the left, it updates the job hes on, site hes on and job number accordingly.

again, thank your for your help.

It would be very helpful if you put the name in C3 exactly as it would appear in column A.
You just had Kieth in C3, but A2 shows a full name (with Keith spelled differently).

Anyway, once you have the correct name in C3
D3: =INDEX($A$3:$A$13,MATCH($C3,$A$2:$A$12,0)) <- notice the row offset in the 2 ranges.
E3: =INDEX($A$5:$A$15,MATCH($C3,$A$2:$A$12,0))
F3: =INDEX($A$4:$A$14,MATCH($C3,$A$2:$A$12,0))

Then fill all 3 down.

Alternative solution using helper column.

Please see the Sample attached.

i need it so multiple men can be put onto the same job and the relevant information be extrcated as such. I have set up two potential methods of displaying this but i cannot get the formulea to work, i was wondering if you had any ideas?

thanks again.

Matt