Get instant live expert help on I need help with excel lookup partial text match

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have a problem regarding to Partial Match with VLOOKUP in Excel
Solved by M. H. in 13 mins
How do I lookup and return an answer to a formula when I want it to do a partial match? Say one spreadsheet has spf1234 and I want it to pull in an answer matching just "1234".
Solved by B. W. in 30 mins
Is there a way to filter data which match only a partial of full cell?
Solved by S. Q. in 18 mins
I am trying to perform an INDEX MATCH function with text data. Basically, I am trying to match a text field in one table, with a text field in another table, to pull out its corresponding identity code. I keep getting an N/A error, when when I perform a MATCH function itself, but the text is clearly present in the lookup table.
Solved by D. S. in 19 mins
Want to have a series of cells return partial text string from a large text string, even if the character is a space
Solved by A. J. in 24 mins