lOOKUP USING TEXT ISSUE

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.

Originally Posted by seckert

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.