Matching string where the string has wildcard character - Excel The 2019 Stack Overflow Developer Survey Results Are In Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) The Ask Question Wizard is Live! Data science time! April 2019 and salary with experienceHow to create Excel (.XLS and .XLSX) file in C# without installing Ms Office?wildcard * in CSS for classesCheck whether a string matches a regex in JSExcel: Wildcard Conditional FormattingExcel define wildcard or variable as a letter of the alphabetSearch uses * in database as a wildcardvba excel - find string wildcardExcel: using vlookup but with wildcards in the arrayVBA Excel wildcard string search, copy and paste to new cellTreating wildcards at standard characters in an INDEX(MATCH(COUNTIF())) formula
Using dividends to reduce short term capital gains?
Word for: a synonym with a positive connotation?
Why are PDP-7-style microprogrammed instructions out of vogue?
How did the audience guess the pentatonic scale in Bobby McFerrin's presentation?
What is the padding with red substance inside of steak packaging?
Sub-subscripts in strings cause different spacings than subscripts
Single author papers against my advisor's will?
Identify 80s or 90s comics with ripped creatures (not dwarves)
Why did Peik Lin say, "I'm not an animal"?
What's the point in a preamp?
how can a perfect fourth interval be considered either consonant or dissonant?
Why not take a picture of a closer black hole?
Presidential Pardon
Example of compact Riemannian manifold with only one geodesic.
My body leaves; my core can stay
Is there a writing software that you can sort scenes like slides in PowerPoint?
Is this wall load bearing? Blueprints and photos attached
Could an empire control the whole planet with today's comunication methods?
What information about me do stores get via my credit card?
How to politely respond to generic emails requesting a PhD/job in my lab? Without wasting too much time
Does Parliament need to approve the new Brexit delay to 31 October 2019?
Can we generate random numbers using irrational numbers like π and e?
Accepted by European university, rejected by all American ones I applied to? Possible reasons?
What force causes entropy to increase?
Matching string where the string has wildcard character - Excel
The 2019 Stack Overflow Developer Survey Results Are In
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
The Ask Question Wizard is Live!
Data science time! April 2019 and salary with experienceHow to create Excel (.XLS and .XLSX) file in C# without installing Ms Office?wildcard * in CSS for classesCheck whether a string matches a regex in JSExcel: Wildcard Conditional FormattingExcel define wildcard or variable as a letter of the alphabetSearch uses * in database as a wildcardvba excel - find string wildcardExcel: using vlookup but with wildcards in the arrayVBA Excel wildcard string search, copy and paste to new cellTreating wildcards at standard characters in an INDEX(MATCH(COUNTIF())) formula
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I have a data in 2 columns.
Column A includes some text with no wildcard characters.
I want to see if the cells in Column A has specific strings. When I use search function, I can use "*" to refer to any number of numbers/letters. Hence I created column B with these strings, which include wildcard characters.
Here, I want to see if a cell in column A has the string in column B, with wildcard characters being satisfied as in the search function.
I hope it is clear.
P.S. A2 has the string in B1.
Thank you in advance for your help.
Aslihan.
excel search match wildcard
edited Mar 8 at 12:37
JvdV
3,0271313
asked Mar 8 at 12:22
Aslıhan HilalAslıhan Hilal
1
add a comment |
I have a data in 2 columns.
Column A includes some text with no wildcard characters.
I want to see if the cells in Column A has specific strings. When I use search function, I can use "*" to refer to any number of numbers/letters. Hence I created column B with these strings, which include wildcard characters.
Here, I want to see if a cell in column A has the string in column B, with wildcard characters being satisfied as in the search function.
I hope it is clear.
P.S. A2 has the string in B1.
Thank you in advance for your help.
Aslihan.
excel search match wildcard
edited Mar 8 at 12:37
JvdV
3,0271313
asked Mar 8 at 12:22
Aslıhan HilalAslıhan Hilal
1
add a comment |
I have a data in 2 columns.
Column A includes some text with no wildcard characters.
I want to see if the cells in Column A has specific strings. When I use search function, I can use "*" to refer to any number of numbers/letters. Hence I created column B with these strings, which include wildcard characters.
Here, I want to see if a cell in column A has the string in column B, with wildcard characters being satisfied as in the search function.
I hope it is clear.
P.S. A2 has the string in B1.
Thank you in advance for your help.
Aslihan.
excel search match wildcard
edited Mar 8 at 12:37
JvdV
3,0271313
asked Mar 8 at 12:22
Aslıhan HilalAslıhan Hilal
1
I have a data in 2 columns.
Column A includes some text with no wildcard characters.
I want to see if the cells in Column A has specific strings. When I use search function, I can use "*" to refer to any number of numbers/letters. Hence I created column B with these strings, which include wildcard characters.
Here, I want to see if a cell in column A has the string in column B, with wildcard characters being satisfied as in the search function.
I hope it is clear.
P.S. A2 has the string in B1.
Thank you in advance for your help.
Aslihan.
excel search match wildcard
excel search match wildcard
edited Mar 8 at 12:37
JvdV
3,0271313
asked Mar 8 at 12:22
Aslıhan HilalAslıhan Hilal
1
edited Mar 8 at 12:37
JvdV
3,0271313
asked Mar 8 at 12:22
Aslıhan HilalAslıhan Hilal
1
edited Mar 8 at 12:37
JvdV
3,0271313
edited Mar 8 at 12:37
JvdV
3,0271313
edited Mar 8 at 12:37
JvdV
3,0271313
3,0271313
asked Mar 8 at 12:22
Aslıhan HilalAslıhan Hilal
1
asked Mar 8 at 12:22
Aslıhan HilalAslıhan Hilal
1
asked Mar 8 at 12:22
Aslıhan HilalAslıhan Hilal
1
1
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I'm unsure what result you are looking for but your example could be used like so:
The formula comes down to: =MATCH("*"&..YOUR SEARCH VALUE..&"*",A:A,0)
Another way to tell that A2 has value from B1 could be:
Formula translates to: ="B"&AGGREGATE(15,3,((SEARCH($B$1:$B$3,A1)/(SEARCH($B$1:$B$3,A1))*ROW($B$1:$B$3))),1)
Put both formulas in cell C1 and drag down, I just added an =IFERROR in both cases
answered Mar 8 at 12:49
JvdVJvdV
3,0271313
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55063166%2fmatching-string-where-the-string-has-wildcard-character-excel%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I'm unsure what result you are looking for but your example could be used like so:
The formula comes down to: =MATCH("*"&..YOUR SEARCH VALUE..&"*",A:A,0)
Another way to tell that A2 has value from B1 could be:
Formula translates to: ="B"&AGGREGATE(15,3,((SEARCH($B$1:$B$3,A1)/(SEARCH($B$1:$B$3,A1))*ROW($B$1:$B$3))),1)
Put both formulas in cell C1 and drag down, I just added an =IFERROR in both cases
answered Mar 8 at 12:49
JvdVJvdV
3,0271313
add a comment |
I'm unsure what result you are looking for but your example could be used like so:
The formula comes down to: =MATCH("*"&..YOUR SEARCH VALUE..&"*",A:A,0)
Another way to tell that A2 has value from B1 could be:
Formula translates to: ="B"&AGGREGATE(15,3,((SEARCH($B$1:$B$3,A1)/(SEARCH($B$1:$B$3,A1))*ROW($B$1:$B$3))),1)
Put both formulas in cell C1 and drag down, I just added an =IFERROR in both cases
answered Mar 8 at 12:49
JvdVJvdV
3,0271313
add a comment |
I'm unsure what result you are looking for but your example could be used like so:
The formula comes down to: =MATCH("*"&..YOUR SEARCH VALUE..&"*",A:A,0)
Another way to tell that A2 has value from B1 could be:
Formula translates to: ="B"&AGGREGATE(15,3,((SEARCH($B$1:$B$3,A1)/(SEARCH($B$1:$B$3,A1))*ROW($B$1:$B$3))),1)
Put both formulas in cell C1 and drag down, I just added an =IFERROR in both cases
answered Mar 8 at 12:49
JvdVJvdV
3,0271313
I'm unsure what result you are looking for but your example could be used like so:
The formula comes down to: =MATCH("*"&..YOUR SEARCH VALUE..&"*",A:A,0)
Another way to tell that A2 has value from B1 could be:
Formula translates to: ="B"&AGGREGATE(15,3,((SEARCH($B$1:$B$3,A1)/(SEARCH($B$1:$B$3,A1))*ROW($B$1:$B$3))),1)
Put both formulas in cell C1 and drag down, I just added an =IFERROR in both cases
answered Mar 8 at 12:49
JvdVJvdV
3,0271313
edited Mar 8 at 13:05
answered Mar 8 at 12:49
JvdVJvdV
3,0271313
answered Mar 8 at 12:49
JvdVJvdV
3,0271313
answered Mar 8 at 12:49
JvdVJvdV
3,0271313
3,0271313
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55063166%2fmatching-string-where-the-string-has-wildcard-character-excel%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
