Consulting

Results 1 to 3 of 3

Thread: Lookup functions ? how to sovle this issue ??? help me please

  1. #1

    Lookup functions ? how to sovle this issue ??? help me please

    Dear all
    How are you all, hope all are fine
    I have attacjed you an excel file that include a small program that i create but
    i faced a a problem at the end
    read what is included in the excel file so youu can understand me as i wrote an example there
    help please
    Attached Files Attached Files

  2. #2
    Moderator VBAX Guru Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    4,997
    Location
    Welcome to VBAX forum. One good thing to remember is that most people have a reluctance to open files from persons they don't know. Best way to increase some activity on your issue is to be very descriptive when detailing your issue. if you don't do that then most people will simply pass over the thread.

    Rather than use Lookup, try VLookup. if you need an example go to www.contextures.com Debra has some wonderful examples there to show how it works. Also my preference is to use the name of the client rather than a numerical number as the search item. In twelve months time I won't remember who was number 5, but I have a better chance of remembering the client name.

    If you need any further assistance, simply indicate in your next post.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  3. #3
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,844

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •