Vlookup string/wildcard within string
How do I lookup a string in a string and populate corresponding column from different sheet?
For example, if Sheet 2 Column A has Ford Ikon
and Column B has Car
and Sheet 1 Column A has Ford Fortuner
, I want to populate Car
in Sheet 1 Column B by matching Ford
.
I want to run this at scale for multiple attributes and rows and hence, looking for a macro
Keyword Data- Input Data
excel vba excel-vba
add a comment |
How do I lookup a string in a string and populate corresponding column from different sheet?
For example, if Sheet 2 Column A has Ford Ikon
and Column B has Car
and Sheet 1 Column A has Ford Fortuner
, I want to populate Car
in Sheet 1 Column B by matching Ford
.
I want to run this at scale for multiple attributes and rows and hence, looking for a macro
Keyword Data- Input Data
excel vba excel-vba
1
This is more of fuzzy matching rather wild card... I think. May be worth looking in to
– urdearboy
Nov 26 '18 at 20:20
1
Adding some more examples would be useful - it's difficult to derive all your matching rules from a single example.
– Tim Williams
Nov 26 '18 at 20:42
Possible duplicate of Matching similar but not exact text strings in Excel VBA projects
– Pᴇʜ
Nov 27 '18 at 8:05
I added example data images. For example, for 'Seats for Ikon' in Input Data, I need macro to lookup into Keyword data and populate 'Car' by matching partial keyword from "Ford Ikon"
– Suresh Kumar
Nov 27 '18 at 13:03
add a comment |
How do I lookup a string in a string and populate corresponding column from different sheet?
For example, if Sheet 2 Column A has Ford Ikon
and Column B has Car
and Sheet 1 Column A has Ford Fortuner
, I want to populate Car
in Sheet 1 Column B by matching Ford
.
I want to run this at scale for multiple attributes and rows and hence, looking for a macro
Keyword Data- Input Data
excel vba excel-vba
How do I lookup a string in a string and populate corresponding column from different sheet?
For example, if Sheet 2 Column A has Ford Ikon
and Column B has Car
and Sheet 1 Column A has Ford Fortuner
, I want to populate Car
in Sheet 1 Column B by matching Ford
.
I want to run this at scale for multiple attributes and rows and hence, looking for a macro
Keyword Data- Input Data
excel vba excel-vba
excel vba excel-vba
edited Nov 27 '18 at 13:00
Suresh Kumar
asked Nov 26 '18 at 20:17
Suresh KumarSuresh Kumar
42
42
1
This is more of fuzzy matching rather wild card... I think. May be worth looking in to
– urdearboy
Nov 26 '18 at 20:20
1
Adding some more examples would be useful - it's difficult to derive all your matching rules from a single example.
– Tim Williams
Nov 26 '18 at 20:42
Possible duplicate of Matching similar but not exact text strings in Excel VBA projects
– Pᴇʜ
Nov 27 '18 at 8:05
I added example data images. For example, for 'Seats for Ikon' in Input Data, I need macro to lookup into Keyword data and populate 'Car' by matching partial keyword from "Ford Ikon"
– Suresh Kumar
Nov 27 '18 at 13:03
add a comment |
1
This is more of fuzzy matching rather wild card... I think. May be worth looking in to
– urdearboy
Nov 26 '18 at 20:20
1
Adding some more examples would be useful - it's difficult to derive all your matching rules from a single example.
– Tim Williams
Nov 26 '18 at 20:42
Possible duplicate of Matching similar but not exact text strings in Excel VBA projects
– Pᴇʜ
Nov 27 '18 at 8:05
I added example data images. For example, for 'Seats for Ikon' in Input Data, I need macro to lookup into Keyword data and populate 'Car' by matching partial keyword from "Ford Ikon"
– Suresh Kumar
Nov 27 '18 at 13:03
1
1
This is more of fuzzy matching rather wild card... I think. May be worth looking in to
– urdearboy
Nov 26 '18 at 20:20
This is more of fuzzy matching rather wild card... I think. May be worth looking in to
– urdearboy
Nov 26 '18 at 20:20
1
1
Adding some more examples would be useful - it's difficult to derive all your matching rules from a single example.
– Tim Williams
Nov 26 '18 at 20:42
Adding some more examples would be useful - it's difficult to derive all your matching rules from a single example.
– Tim Williams
Nov 26 '18 at 20:42
Possible duplicate of Matching similar but not exact text strings in Excel VBA projects
– Pᴇʜ
Nov 27 '18 at 8:05
Possible duplicate of Matching similar but not exact text strings in Excel VBA projects
– Pᴇʜ
Nov 27 '18 at 8:05
I added example data images. For example, for 'Seats for Ikon' in Input Data, I need macro to lookup into Keyword data and populate 'Car' by matching partial keyword from "Ford Ikon"
– Suresh Kumar
Nov 27 '18 at 13:03
I added example data images. For example, for 'Seats for Ikon' in Input Data, I need macro to lookup into Keyword data and populate 'Car' by matching partial keyword from "Ford Ikon"
– Suresh Kumar
Nov 27 '18 at 13:03
add a comment |
0
active
oldest
votes
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%2f53488397%2fvlookup-string-wildcard-within-string%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f53488397%2fvlookup-string-wildcard-within-string%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
1
This is more of fuzzy matching rather wild card... I think. May be worth looking in to
– urdearboy
Nov 26 '18 at 20:20
1
Adding some more examples would be useful - it's difficult to derive all your matching rules from a single example.
– Tim Williams
Nov 26 '18 at 20:42
Possible duplicate of Matching similar but not exact text strings in Excel VBA projects
– Pᴇʜ
Nov 27 '18 at 8:05
I added example data images. For example, for 'Seats for Ikon' in Input Data, I need macro to lookup into Keyword data and populate 'Car' by matching partial keyword from "Ford Ikon"
– Suresh Kumar
Nov 27 '18 at 13:03