I am not sure what you are asking, but if it is how are you sure it is an
exact match, add a ,False as the last step in the Vlookup function. It will
give you an error if there is not an exact match.

"nebb" wrote:


I have a table array ,sorted by members last name, against which I use
the VLOOKUP worksheet function to locate the name of an individual and
return another piece of data in the array relevant to that individual..

Is there some way that I can check to see if the next name in the array
is the same as the one indicated in my VLOOKUP function?


--
nebb
------------------------------------------------------------------------
nebb's Profile: http://www.excelforum.com/member.php...fo&userid=8981
View this thread: http://www.excelforum.com/showthread...hreadid=383976