Looking up Customers with a masterlist vs a new list created from scratch.

[wildcat520]

I have 2 worksheets. Lets call them WorkSheet1 (W1), WorkSheet2 (W2).


WS1 is my analysis sheet with piviot table to WS2 customer list that works! I need to check if my list of text words match a text column in WS2 to plug in missing customer account numbers I need. I do have a customers numbers column I have associated with WS1 the best I could. I need to check my work. WS2 has the correct number and text columns but it has 30K rows. My WS1 has about 400rows. Its taken me forever to eyeball these lists I have 150 and I need 200 more. I have figured out vlookup with #'s, and the left function. Now I need a way to find the rest of the my customer numbers list.
What I am thinking is that I need to somehow associate the first few letters from my text list with the master text list in W2 and then plug in there rest of the 200 customer numbers I need. I hope I gave enough info and made sense.
Summary: I need to fill in missing customer account numbers from a master list. Thank you all I do have skype and yahoo messenger if that helps to have a dynamic conversation.