Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Vivek Patel   on Oct 20 In MS Office Category.

  
Question Answered By: Jeanette Greene   on Oct 20

I may have misunderstood
Harrison, but I thought he was wanting to look for names WITHIN the
cell . . . BECAUSE he might not get an exact match  of the whole cell
value, such as an employee who was entered without a middle initial,
versus his other list, which might include the middle initial in the
employee's name. I did think the rest of your code looked great,
so I'm going to save it to my code examples for future use myself,
heheh, thanks--but I haven't tested it yet either, so if you test it
out and adjust it, I'd be interested in the update.

Anyway, I'm looking forward to hearing from Harrison as to if
these examples work, or a combination of them. Anyone working with
this, please keep me informed (at least here in the group) if you
find other ways to do this, since it comes up in my work  on occasion.

Share: 

 

This Question has 12 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on How to make WorksheetFunction.MATCH OR .VLOOKUP work? Or get search suggestion and latest updates.


Tagged: