Beyond VLOOKUP

N

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?
 
B

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.
 
R

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
 
R

RagDyer

Please *don't* multi-post.

See the answer to your first post in the excel group!
 
Top