VLOOKUP and MATCH w/ name search?

[LTUser54]

I have a worksheet with info from 2 databases. I'm trying to match names
in different columns that have different formats. One has LN, FN,
Initial format with info presented in 1 column (Column B), the other
has LN,FN with info in 2columns, H:I, all names sorted alpha ascending.


Due to the queries involved (PeopleSoft & Employease DB's), I do not
have a matching determinate like SSN.

I poked around using MS Help - that was an exercise in frustration, and
even tried to cobble together a funtion using VLOOKUP and MATCH (or LEN)
was futile. The shortest employee name is 4 characters.

Can you give me an example I can use for this problem? Any help is
sincerely appreciated.

Thanks.

Mark
Boston

 

[Guest]

You can check this page:
http://www.contextures.com/xlFunctions03.html

The example 4 of INDEX and MATCH can be useful in your case.

Hope this helps,
Miguel.

 

[Don Guillett]

you could do this first to change dd, ee to dd,ee

Sub trimcells()
For Each c In Selection
c.Value = Application.Substitute(c, ", ", ",")
Next c
End Sub