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?

 

[Guest]

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.

 

[Guest]

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

 

[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!