Help me with what seems simple

S

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
 
P

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
 
S

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

Ardus Petus

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

HTH
--
AP

Steve said:
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.
Click to expand...
 
P

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
 
Top