I have created a worksheet that have the following

A B
user1 user
user
user

cell A1 is actually display with the help of a Function username(). Column B (B1:B3) is being defined as "mylist"

What I intend to achieve using VBA is

When user1 login, cell C1 should shown "user1". However, if user2 or user3 login, cell C1 should become a drop down list showing the name of user1,user2,user3 in the list. I have used MATCH() to compare A1 to B1:B2 but doesn't seem to get the comparison work

Can someone help? Thank you.