Re: VLOOKUP and LEN/ISNA to match names?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


I can easily do that, but the problem is there is no match with the FN
and/or initial from the concatenated name that will match the B column,
which has LN,FN Initial format.

Do you see the dilemma?

In addition, I would like to get a FALSE notation in the formula cell,
so it prints "OK" or "LN Mismatch" or something like that, if there is
no LN name match between the two columns.

If somebody can tell me a LN VLOOKUP match between the 2 columns I will
be very grateful...

Mark
boston


--
LTUser54
------------------------------------------------------------------------
LTUser54's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33459
View this thread: http://www.excelforum.com/showthread.php?threadid=544339

.

Relevant Pages

  • Re: Encrypted files inaccessible after reinstalling OS
    ... Your only hope is restoring the ORIGINAL profile from before the ... EFS is very good at what it does and there are no back doors. ... "Mark Jones" wrote in message ... >>An easier way to read newsgroup messages: ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Desktop and Documents problems
    ... Create a new user, and profile, and see if the errors are there also. ... it has a corrupt Default Profile. ... Mark L. Ferguson ... "Professor Joe" wrote: ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Duplicate Administrators ????
    ... current profile, ... "Mark L. Ferguson" wrote: ... Go to start/run, as the default admin, and type: ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Duplicate Administrators ????
    ... probleml, just the fact that they seem duplicates ... "Mark L. Ferguson" wrote: ... current profile, ...
    (microsoft.public.windowsxp.help_and_support)