Excel partial match [Solved]
machoman4lyf
- Posts
- 4
- Registration date
- Sunday March 18, 2018
- Last seen
- April 13, 2018
- Posts
- 4
- Registration date
- Sunday March 18, 2018
- Last seen
- April 13, 2018
Related:
- Excel partial match
- Partial match excel - Best answers
- Partial match in excel - Best answers
- Perform a Partial Cell Match in Excel - How-To - Excel
- Excel partial match two columns - Forum - Excel
- Excel: Partial Matches in 2 Different Cells ✓ - Forum - Excel
- EXCEL: Partial Cell matches in dfrnt sheets ✓ - Forum - Excel
- Compare multiple columns in excel for matches - How-To - Excel
4 replies
Best answer
- Posts
- 1834
- Registration date
- Monday August 16, 2010
- Status
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
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
Glad we were able to help! Love us? Write us a review! Rate CCM
2937 users have said thank you to us this month
- Posts
- 1207
- Registration date
- Thursday July 24, 2014
- Status
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.
Sadly, your time has been wasted on this thread:-
https://www.excelforum.com/excel-general/1224481-excel-partial-match-query.html
Cheerio,
vcoolio.
- Posts
- 1834
- Registration date
- Monday August 16, 2010
- Status
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
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
- Posts
- 4
- Registration date
- Sunday March 18, 2018
- Last seen
- April 13, 2018
-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