Vlookup when Lookup_Value starts with "~" fails...

[lovallee]

Vlookup when Lookup_Value starts with "~" seems to always returns N/A even if there a value to return.

I have rechecked my formula several time, its works with all value on my list except when lookup_value starts with "~".

~ is obtained on my keyboard (set as English United States) by clicking on
Shift + the key just left of the "1" key.

Anybody knows how to resolve that problem without changing the ~ in the lookup_value field (since this caracter is necessary to keep the field as a primary key)

Thanks

Louis

 

[Brian from Maui]

Re: Vlookup when Lookup_Value starts with "~" fail

See,

http://www.mrexcel.com/board2/viewtopic.php?t=73771&highlight=vlookup

 

[lovallee]

Re: Vlookup when Lookup_Value starts with "~" fail

Thanks!

I have tried the search function of the board to find it but I was unsucessful withthe following query: +vlookup +~

May I ask you the query syntax you entered to find it ?

Thanks

 

[Brian from Maui]

Re: Vlookup when Lookup_Value starts with "~" fail

Thanks!

I have tried the search function of the board to find it but I was unsucessful withthe following query: +vlookup +~

May I ask you the query syntax you entered to find it ?

Thanks

Vlookup ~ and the most important search criteria...Aladin Akyurek

 

[just_jon]

Re: Vlookup when Lookup_Value starts with "~" fail

Thanks!

I have tried the search function of the board to find it but I was unsucessful withthe following query: +vlookup +~

May I ask you the query syntax you entered to find it ?

Thanks

Vlookup ~ and the most important search criteria...Aladin Akyurek

2nd that.