Vlookup does not work & Wildcard available?

Re: Vlookup does not work & Wildcard available?

You do not have the EXACT same value typed in. One of the values has a space following the text.

Re: Vlookup does not work & Wildcard available?

The text in cell G2 has space character at the end and cell K2 doesn't.

Re: Vlookup does not work & Wildcard available?

Rather than adding spaces you should make certain that entries DO NOT have extra spaces (or other characters) after either the source or destination values.

Re: Vlookup does not work & Wildcard available?

Quote from tradertt

But even if I type in the space - Vlookup still does not work

That's because it's not really a Space. I copied the character, from the toolbar, then pasted it to the end of the other text, again via the toolbar and it picked it up.

However, as Robert states, fix the problem rather than re-producing it!

Re: Vlookup does not work & Wildcard available?

Sounds like maybe another "no-break space" character issue...

I think I talked about how to clean them in here somewhere before. By chance is the source data SAP??? They like to use the no-break spaces a lot.

Edit:
Here's a previous thread that talks about how to resolve char 160 issues.
http://www.ozgrid.com/forum/showthread.php?t=19415

Just make sure you read my post on the thread because the typical TRIM function won't strip the NB Spaces.

Re: Vlookup does not work & Wildcard available?

What I generally do is copy the character from within the Formula bar (Ctrl+C), then go to Edit>Replace and paste (Ctrl+V) into the Find what: box and leave the Replace with: blank and click Replace All.

Re: Vlookup does not work & Wildcard available?

Quote from Dave Hawley

What I generally do is copy the character from within the Formula bar (Ctrl+C), then go to Edit>Replace and paste (Ctrl+V) into the Find what: box and leave the Replace with: blank and click Replace All.

AHHHH!!! :yikes: What's this? A manual action! :nono:

Well, sure... OK if you want to do it the EASY way... sheesh.