Vlookup with underscore

Canoun

New Member
Joined
Sep 11, 2002
Messages
1
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.
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Dave Patton

Well-known Member
Joined
Feb 15, 2002
Messages
4,971
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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

Well-known Member
Joined
Feb 15, 2002
Messages
4,971
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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.
 

Forum statistics

Threads
1,144,310
Messages
5,723,637
Members
422,506
Latest member
mdindas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top