Yesterday I was given an excellent answer by Ken Butters who supplied me with a nice formula for my problem. But I need to refine it a bit. There was something I had not considered. What I had not considered was the inconsistencies of the columns like some name are in UPERCASSE some not and some with a combination of both. So I need for the below formula to reflect that situation.
=IF(ISNA(VLOOKUP(A1363 Refining a XLS formula
,B:B,1,FALSE)),CONCATENATE(A1363," = No match in AMS"),VLOOKUP(A1363,B:B,1,FALSE))