Beyond VLOOKUP
 

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

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

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


"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

The next name is in the Next Row.


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

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


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=383976

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" wrote in message
...

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