VLOOKUP not acting the way I think it should

[RIKIL]

I have a VLOOKUP function that looks at a cell that has a folder path, like this: Z:\Statements\Bob

My VLOOKUP function wasn't returning the data even though I knew I had set the function up right. What I found is that if I remove the slashes ("\") from the folder path, the function will work fine.

The problem is that I need to preserve the dashes or use something in its place because it is a folder path and I need to retain the full path.

I tried switching the slashes to dashes like this: Z:-Statements-Bob

but that didn't work either.

Anyone run across this and have any ideas?

[Whizbang]

Try doing something like this:

=VLOOKUP("*Z:\Statements\Bob*",A:B,2,FALSE)

It may be that you have a space or some other character before or after the string that is making Vlookup skip by the value.

Using backslashes worked just fine for me, as long as the two strings were exactly the same, or I used asterisks.

[SpellWeaver]

Hello... Input the VLOOKUP with both the files on. Then close the file with the tablearray. Your formula with the slashes will remain the way you want it to be.

Thx..SW