Find a value from sheet 1, in sheet 2, then copy value of data later in the row of sheet 2

Hello, I wonder if anyone can assist me.
A colleague currently cuts and pastes data a spreadsheet to a word document after doing a manual (!) search to match the data. I want to automate this.
Sheet 1 has a column eg column A with a value (eg ws567).
Sheet 2 has a column eg column C that may have a corresponding value.
If it does, I need to copy a value from a later column (eg column E) in sheet 2, to column (say B) in sheet 1

Can this be done without using VB?
Thanks in advance,

Steve

It's probably easier with VBA but you can do it with a formula. Do the values in column B need to be in the row that they are located in in column C or in a list without spaces? It would be helpful if you could upload an example workbook with some dummy data and what you want the result to be like. Click go advanced and then attachments to attach a workbook.

Thanks for quick response. Simplified example attached.
The results from sheet 2 need to be in a column in same row as sheet 1 with the search value.
Hope that's clear.

Ah ok, that makes things much easier. You can use a vlookup formula like this:
=VLOOKUP(C4,Sheet2!B$7:H$9,7,FALSE)
in D4 and copy down.

It works a treat! Well done that person :-)