• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Userform for company database

monalisa

monalisa

New Member
Hello!

My question is how to search a database and display information specific to a person and also by his unique id that was system generated. The main project was creating a database using userforms and now it is required to devise method to find a particular seller and his sales or a particular client and his purchases. Is this possible in an easy way??

Many thanks !!
 
Luke M said:
Sounds like you'll want to use some VLOOKUP type formulas.
http://chandoo.org/wp/2012/03/30/comprehensive-guide-excel-vlookup/

The family of lookup functions (LOOKUP/VLOOKUP/HLOOKUP) are very useful when you want to search a data table for a particular item, and return a corresponding value.
Click to expand...




Hello Luke!

Finally my database is ready which is taking inputs from userforms, there were some issues regarding vba codes. Now , next what I tried to do was input a sellerid from dropdown dynamic list (using offset and not table). Now for this particular seller id i need all the transactions. If i use vlookup, its giving me only one value. Is it possible to use vlookup for the above job?

Many thanks!
 
Hi ,

VLOOKUP will only retrieve the first matching entry. If you wish to retrieve all matching entries , you need to use a different kind of technique. Depending on the number of entries , you can use different techniques such as using a loop , using a formula consisting of SMALL , INDEX and MATCH , or using the AutoFilter method.

If you can upload a sample workbook with the same layout as your working one , and with some sample data in it , someone here can do it for you.

Narayan
 
You must log in or register to reply here.
Back
Top