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

[Sharif Taha]

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

[Aussiebear]

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 (http://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.

[p45cal]

cross posted without links:
http://www.excelguru.ca/forums/showthread.php?5273-Lookup-fumctions-how-to-sovle-this-issue-help-me-please