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.

1 reply

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