| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
EXCEL Wild Cards
I'm having a problem with wild cards (*,?,!) when doing the vlookup function.
Unfortunately, my comparison data contains these characters so I end up picking up the wrong data most of the time. Is there any way to turn these wild cards off? Thank you in advance, Scott |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
EXCEL Wild Cards
My favorite!
=VLOOKUP(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"~"," ~~"),"?","~?"),"*","~*"), Sheet2!$A:$B,2,FALSE) ! isn't a wildcard. ~ is used as an "escape" character to mean the next character shouldn't be treated as a wildcard. NPVSRUS wrote: I'm having a problem with wild cards (*,?,!) when doing the vlookup function. Unfortunately, my comparison data contains these characters so I end up picking up the wrong data most of the time. Is there any way to turn these wild cards off? Thank you in advance, Scott -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
EXCEL Wild Cards
Thank You Sir!
"Dave Peterson" wrote: My favorite! =VLOOKUP(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"~"," ~~"),"?","~?"),"*","~*"), Sheet2!$A:$B,2,FALSE) ! isn't a wildcard. ~ is used as an "escape" character to mean the next character shouldn't be treated as a wildcard. NPVSRUS wrote: I'm having a problem with wild cards (*,?,!) when doing the vlookup function. Unfortunately, my comparison data contains these characters so I end up picking up the wrong data most of the time. Is there any way to turn these wild cards off? Thank you in advance, Scott -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mass Changes in Excel using Wild Cards or other | Excel Discussion (Misc queries) | |||
| Wild Cards with IF stmt | Excel Worksheet Functions | |||
| wild cards? | Excel Discussion (Misc queries) | |||
| If Statement Using Wild Cards | Excel Worksheet Functions | |||
| Wild Cards With Arrays | Excel Discussion (Misc queries) | |||
Linear Mode
