Excel partial match [Solved]

machoman4lyf 4 Posts Sunday March 18, 2018Registration date April 13, 2018 Last seen - Mar 18, 2018 at 11:42 AM - Latest reply: machoman4lyf 4 Posts Sunday March 18, 2018Registration date April 13, 2018 Last seen
- Mar 25, 2018 at 08:54 AM
Hello,

Hello,


I have a small query related to Excel Search function. Suppose I need to search the below data in target cell which has some errors , but a partial match of data is being accepted. Which function can we use as I have tried Match & Vlookup it only searches for exact data. Is there any function for partial match of data available ???





Regards


See more 

Your reply

6 replies

Best answer
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Mar 18, 2018 at 04:11 PM
1
Thank you
machoman4lyf, Good afternoon.

Please, next time attach your Excel file not an image.
It's better for all of us to help you.

Suppose:
Your table is at D1:E6
Your column A the values to be searched.
Column B the value found as result.

Try to use:
B1 --> Formula -->
=IF(A1="","",IFERROR(VLOOKUP("*" & A1 & "*",$D$1:$E$6,2,FALSE),"-- NOT FOUND --"))

I did a little example for you:
https://www.sendspace.com/file/isezwv

Is that what you want?
I hope it helps.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão

Thank you, Mazzaropi 1

Something to say? Add comment

CCM has helped 1297 users this month

machoman4lyf 4 Posts Sunday March 18, 2018Registration date April 13, 2018 Last seen - Mar 18, 2018 at 10:41 PM
HI Marcílio Lobão ,

Thanks a lot for your valuable reply

Please find the attached excel file, i am getting error for A3, A4, A8, A9 where data match is available.

Please guide

https://www.sendspace.com/file/ah00x5

Regards
Respond to Mazzaropi
vcoolio 1200 Posts Thursday July 24, 2014Registration dateModeratorStatus October 12, 2018 Last seen - Mar 19, 2018 at 08:14 AM
0
Thank you
Good evening Marcilio,

Sadly, your time has been wasted on this thread:-

https://www.excelforum.com/excel-general/1224481-excel-partial-match-query.html

Cheerio,
vcoolio.
machoman4lyf 4 Posts Sunday March 18, 2018Registration date April 13, 2018 Last seen - Mar 25, 2018 at 08:54 AM
thanks marcillio & Mazzaropi .

Sorry for the late reply, the query has been addressed
Respond to vcoolio
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Mar 19, 2018 at 10:23 AM
0
Thank you
vcoolio, Good morning.

Thank you very much for the warning.

Unfortunately the users just arrived at the forum do not use a few minutes even to read the rules of courtesy and ethics of use of the forum.

In the anxiety to get immediate answers they pose the same questions at the same time in various Excel forums.
So several people spend time trying to help on the same subject.

It is a waste of effort and knowledge received gratuitously that becomes useless.
Often users even come back to say they've solved the issues elsewhere.

Have a great day with lots of health and a very productive week.

Greetings from Brazil !
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
Respond to Mazzaropi
vcoolio 1200 Posts Thursday July 24, 2014Registration dateModeratorStatus October 12, 2018 Last seen - Mar 20, 2018 at 08:15 AM
0
Thank you
Good day Marcilio,

Forum Expert Leelnich over at Excel Forum acknowledged your contribution. I've asked the OP to at least acknowledge your contribution as it was your formula that did the trick anyway.

Cheerio,
vcoolio.
Respond to vcoolio