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

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

I understand it, but for some reason, not getting the result.
Here's what I have...
=VLOOKUP(E2,Sheet1!B1:B800,6,FALSE)

I understand it like this;
Lookup the value in E2 on current sheet within the B1:B600 range on Sheet1.
Then report back the value 6 columns across from B (i.e. G, B=1, c=2... g=6)
I.e. E2, matches the value in Sheet1!B9 so the answer is the value in
Sheet1!G9 ?

But I get #N/a for every result. Which is not right.



"PH NEWS" wrote:

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.

=VLOOKUP(E2,Sheet1!B1:G800,6,FALSE)

HTH
--
AP

"Steve" a écrit dans le message de
...
I understand it, but for some reason, not getting the result.
Here's what I have...
=VLOOKUP(E2,Sheet1!B1:B800,6,FALSE)

I understand it like this;
Lookup the value in E2 on current sheet within the B1:B600 range on
Sheet1.
Then report back the value 6 columns across from B (i.e. G, B=1, c=2...
g=6)
I.e. E2, matches the value in Sheet1!B9 so the answer is the value in
Sheet1!G9 ?

But I get #N/a for every result. Which is not right.



"PH NEWS" wrote:

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.

Six columns across is correct, but you to include those columns within the
table array, so where you have B1:B800 you should have B1:F800, F is the 6th
column in your array.

Hope this helps

SPL

"Steve" wrote in message
...
I understand it, but for some reason, not getting the result.
Here's what I have...
=VLOOKUP(E2,Sheet1!B1:B800,6,FALSE)

I understand it like this;
Lookup the value in E2 on current sheet within the B1:B600 range on
Sheet1.
Then report back the value 6 columns across from B (i.e. G, B=1, c=2...
g=6)
I.e. E2, matches the value in Sheet1!B9 so the answer is the value in
Sheet1!G9 ?

But I get #N/a for every result. Which is not right.



"PH NEWS" wrote:

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.