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

Solved/Closed
ozetrezure Posts 2 Registration date Wednesday 14 August 2013 Status Member Last seen 14 August 2013 - 14 Aug 2013 à 09:58
ozetrezure Posts 2 Registration date Wednesday 14 August 2013 Status Member Last seen 14 August 2013 - 14 Aug 2013 à 22:25
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 14 August 2013 Status Member Last seen 14 August 2013 1
14 Aug 2013 à 22:25
Never mind... I managed to get an answer elsewhere;

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