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

[Solved/Closed]
Report
Posts
2
Registration date
Wednesday August 14, 2013
Status
Member
Last seen
August 14, 2013
-
Posts
2
Registration date
Wednesday August 14, 2013
Status
Member
Last seen
August 14, 2013
-
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

Posts
2
Registration date
Wednesday August 14, 2013
Status
Member
Last seen
August 14, 2013
1
Never mind... I managed to get an answer elsewhere;

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

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month