I always find it easier to use the function button, (fx) when I'm making a
V-Lookup. If on sheet 2 your Wstations names start in row 2, click on f2,
then the fx button and pick V-Lookup. Your lookup value is the wstation name
in e2. Your table array is the info you have on sheet 1, so it's B to F,
depending on how many rows of info you have and where it starts. For example
if your info went down to row 100, your table array would be B2:F100. The
Column index num is the position the data you want to lookup appears in your
info. In your situation B is 1, C is 2 and so on, so F is 5. 5 is your col
index num. The final part, the range lookup enter False, this makes sure an
exact match is found.

Hope this helps and I haven't over complicated anything

SPL
"Steve" wrote in message
...
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