Beyond VLOOKUP

[nebb]

I have a table array ,sorted by member’s 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?

[bj]

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 member’s 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
>
>

[Cody]

Is the next name in the next row or the next column?


"nebb" wrote:

>
> I have a table array ,sorted by member’s 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
>
>

[nebb]

The next name is in the Next Row.

[Ron Coderre]

Have you tried experimenting with Pivot Tables?
A Pivot Table would group the details by name. The key is to pick any one of the fields for the Data section and set it to "Count Of"

Exampel: In the Pivot Table setup layout section:
Row: Name, Product, Qty, Discount
Data: Count of Product

Would that help?
Ron

[RagDyer]

Please *don't* multi-post.

See the answer to your first post in the excel group!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"nebb" <[email protected]> wrote in message
news:[email protected]...
>
> I have a table array ,sorted by member's 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
>

[bj]

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 member’s 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
>
>

[Cody]

Is the next name in the next row or the next column?


"nebb" wrote:

>
> I have a table array ,sorted by member’s 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
>
>

[RagDyer]

Please *don't* multi-post.

See the answer to your first post in the excel group!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"nebb" <[email protected]> wrote in message
news:[email protected]...
>
> I have a table array ,sorted by member's 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
>

[bj]

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 member’s 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
>
>

[RagDyer]

Please *don't* multi-post.

See the answer to your first post in the excel group!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"nebb" <[email protected]> wrote in message
news:[email protected]...
>
> I have a table array ,sorted by member's 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
>

[Cody]

Is the next name in the next row or the next column?


"nebb" wrote:

>
> I have a table array ,sorted by member’s 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
>
>

[bj]

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 member’s 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
>
>

[Cody]

Is the next name in the next row or the next column?


"nebb" wrote:

>
> I have a table array ,sorted by member’s 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
>
>

[RagDyer]

Please *don't* multi-post.

See the answer to your first post in the excel group!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"nebb" <[email protected]> wrote in message
news:[email protected]...
>
> I have a table array ,sorted by member's 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
>

[RagDyer]

Please *don't* multi-post.

See the answer to your first post in the excel group!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"nebb" <[email protected]> wrote in message
news:[email protected]...
>
> I have a table array ,sorted by member's 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
>

[bj]

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 member’s 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
>
>

[Cody]

Is the next name in the next row or the next column?


"nebb" wrote:

>
> I have a table array ,sorted by member’s 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
>
>

[RagDyer]

Please *don't* multi-post.

See the answer to your first post in the excel group!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"nebb" <[email protected]> wrote in message
news:[email protected]...
>
> I have a table array ,sorted by member's 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
>

[Cody]

Is the next name in the next row or the next column?


"nebb" wrote:

>
> I have a table array ,sorted by member’s 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
>
>

[bj]

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 member’s 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
>
>

[RagDyer]

Please *don't* multi-post.

See the answer to your first post in the excel group!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"nebb" <[email protected]> wrote in message
news:[email protected]...
>
> I have a table array ,sorted by member's 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
>

[bj]

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 member’s 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
>
>

[Cody]

Is the next name in the next row or the next column?


"nebb" wrote:

>
> I have a table array ,sorted by member’s 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
>
>

[RagDyer]

Please *don't* multi-post.

See the answer to your first post in the excel group!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"nebb" <[email protected]> wrote in message
news:[email protected]...
>
> I have a table array ,sorted by member's 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
>

[Cody]

Is the next name in the next row or the next column?


"nebb" wrote:

>
> I have a table array ,sorted by member’s 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
>
>

[bj]

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 member’s 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
>
>

[RagDyer]

Please *don't* multi-post.

See the answer to your first post in the excel group!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"nebb" <[email protected]> wrote in message
news:[email protected]...
>
> I have a table array ,sorted by member's 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
>

[Cody]

Is the next name in the next row or the next column?


"nebb" wrote:

>
> I have a table array ,sorted by member’s 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
>
>

[bj]

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 member’s 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
>
>

[Cody]

Is the next name in the next row or the next column?


"nebb" wrote:

>
> I have a table array ,sorted by member’s 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
>
>

[bj]

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 member’s 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
>
>

[RagDyer]

Please *don't* multi-post.

See the answer to your first post in the excel group!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"nebb" <[email protected]> wrote in message
news:[email protected]...
>
> I have a table array ,sorted by member's 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
>

[bj]

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 member’s 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
>
>

[Cody]

Is the next name in the next row or the next column?


"nebb" wrote:

>
> I have a table array ,sorted by member’s 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
>
>

[RagDyer]

Please *don't* multi-post.

See the answer to your first post in the excel group!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"nebb" <[email protected]> wrote in message
news:[email protected]...
>
> I have a table array ,sorted by member's 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
>

[bj]

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 member’s 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
>
>

[Cody]

Is the next name in the next row or the next column?


"nebb" wrote:

>
> I have a table array ,sorted by member’s 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
>
>

[RagDyer]

Please *don't* multi-post.

See the answer to your first post in the excel group!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"nebb" <[email protected]> wrote in message
news:[email protected]...
>
> I have a table array ,sorted by member's 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
>