Beyond VLOOKUP

  • Thread starter Thread starter nebb
  • Start date Start date
N

nebb

I have a table array ,sorted by member’s last name, against which I us
the VLOOKUP worksheet function to locate the name of an individual an
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 arra
is the same as the one indicated in my VLOOKUP function?
:eek
 
If, for example, this was your original lookup formula:

=VLOOKUP(C1,A2:B25,2,0)

Try something like this to return the name in the next cell down:

=INDEX(A2:A25,MATCH(C1,A2:A25,0)+1)

If you would just like a "True" or "False" return, try this:

=INDEX(A2:A25,MATCH(C1,A2:A25,0)+1)=C1

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Back
Top