Quote Originally Posted by seckert View Post
The lookup will work fine if you can standardize the names. (i.e. "Best Buy 2" and "BestBuy2" are not comparable text strings. ) and sort your master table by "C_Name" . Or you can copy the Client ID to the right of the Name and use vlookup. You won't have to resort, but you will still need to standardize the names.
--------------------------------------------------------------------------------

First of all, thanks for the reply to my question....


__VLOOKUP(D2,$B$2:$C$11,2,FALSE)
If I use Lookup Value (Search for the first 4 to 5 character within the text string would that work....something like

**Vlookup(search(,d2,4),$b$2:$c$11,2,false)....

End result that I would need is Client ID. I'm hoping the somekind of complex function would enable to search for Client ID.