VLOOKUP ~ symbol

D

Dave Peterson

And you may not get the answer you want when your data has asterisks or question
marks, too.

=VLOOKUP(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"~","~~"),"?","~?"),"*","~*"),
Sheet2!$A:$B,2,FALSE)

would be one way to avoid all three problems.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete all data after a symbol in a field 0
Section Breaks 0
Help With VLOOKUP 2
Same forumula returns both 0 & N/A 2
Use & with two formulas 2
Word VBA - Want to test if Full Name is NOT Present in document 0
Multiple VLOOKUP in an IF statement 2
Vlookup 1

Top