Vlookup with underscore

[Canoun]

I am trying to use the vlookup function to lookup names in a list with the format XYZ_W. Some of the time it works but sometimes not. The underscore seems to be the problem but I do not know why or how to fix it.

 

[Dave Patton]

On 2002-09-12 20:21, Canoun wrote:
I am trying to use the vlookup function to lookup names in a list with the format XYZ_W. Some of the time it works but sometimes not. The underscore seems to be the problem but I do not know why or how to fix it.

Please clarify your question:
1) what is the exact formula that you are using
2) show an example
3) is your lookup range sorted? see next point

3) if you require an exact match ensure that
the last parameter in your formula is 0 "zero" or False

 

[Dave Patton]

On 2002-09-12 20:21, Canoun wrote:
I am trying to use the vlookup function to lookup names in a list with the format XYZ_W. Some of the time it works but sometimes not. The underscore seems to be the problem but I do not know why or how to fix it.
[/quote]


Moderators have not posted hints for New Posters; consequently, I paste the following from Microsoft Newgroup

see
http://www.cpearson.com/excel/newposte.htm
and
http://www.mvps.org/dmcritchie/excel/posting.htm

Both written by leading Experts and both providing very valuable advice that
helps you get the best out of Newsgroups and especially to get the assistance you need.

Here are a few important notes relating to current problems:

2. Make your subject line descriptive. You'll get more replies because most
potential helpers zoom in on their area of expertise.

4. Try and solve the problem yourself first. *Help* in Excel is better than you think.The action of spending some time trying to help yourself will be a valuable learning exercise even if you fail to solve the problem.