I have a single Workbook, with 2 Worksheets.

Sheet 1:
Column B has a list of Workstation names
Column F has a Result of that workstations deployment

Sheet2:
Column E has a list of workstation names.

I need to do this Query;
On sheet2, match the workstation to a workstation on Sheet1, then return the
value of Column:F
Obviously some sort of Vlookup, but I can't get the right formula.

Steve