Re: VLOOKUP and LEN/ISNA to match names?

Tech-Archive recommends: Fix windows errors by optimizing your registry


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)
  • Re: Starting Firstbase at the ALL STAR GAME
    ... Of course they do.....and you are only bitter on Teixeira because your owners pissed him off and he said "fuck Boston" ... Mark was safe at home. ... get the facts straight before acting like a MORON. ... Youkilis dropping 91 POINTS in his average must have made Boston fans change their minds and vote for Teixeira ...
    (alt.sports.baseball.ny-yankees)