Lookup same Entry A1 in 2 worksheet & return B1 from 2nd w/sheet

Solved/Closed
ozetrezure Posts 2 Registration date Wednesday August 14, 2013 Status Member Last seen August 14, 2013 - Aug 14, 2013 at 09:58 AM
ozetrezure Posts 2 Registration date Wednesday August 14, 2013 Status Member Last seen August 14, 2013 - Aug 14, 2013 at 10:25 PM
Hi,

I have 2 worksheets.

"Master" = Sheet 1
"Status" = Sheet 2

In "Master" Worksheet there are 3 columns, A1-User ID, B1-Username, C1-Status
In "Status" Worksheet there are 2 columns, A1-User ID, B1-Status

Now what I need to get is the status from "Status" worksheet B1 and have the data appear on "Master" worksheet C1-Status relevant User id.

Please spell this out to me I just don't get Vlookup. :-) and need to produce this quickly.

Thank you.
Related:

1 response

ozetrezure Posts 2 Registration date Wednesday August 14, 2013 Status Member Last seen August 14, 2013 1
Aug 14, 2013 at 10:25 PM
Never mind... I managed to get an answer elsewhere;

=VLOOKUP(A2,Status!$A$2:$B$61,2,0)
1