Help me with what seems simple

[Steve]

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

[PH NEWS]

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>

[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.
>

[Ardus Petus]

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

HTH
--
AP

"Steve" <[email protected]> a écrit dans le message de
news:[email protected]...
> 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.
> >

[PH NEWS]

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" <[email protected]> wrote in message
news:[email protected]...
> 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.
> >