I have two worksheets, Ws1 is my data worksheet and Ws2 is my reference worksheet. I need macro to search for all the names in Ws1 A and match if it is listed in my reference worksheet (ws2 column A) and will return the corresponding value of membership status from Ws2 Col B to Ws1 Col B. In below example, Ws1 under Membership Status, B2 must have a value "Not a member" and B3 as "Member" Please help as I am not good in macro and have thousand of members to run the macro through. I have been using excel with Index, Match and search in excel [=INDEX(Membership,Found,MATCH(TRUE,ISNUMBER(SEARCH(Name,M9)),0))] and it takes so much time considering the amount of data. Thank you in advance.