Excel VBA: vLookup on a specific column in a Named Table and replacing value if it matches with multiple criteria and wildcard2019 Community Moderator ElectionExcel formula for VLOOKUP with changing look-up value across all rows?Excel VBA that searches by header name not columnAlternative to wildcard searching for multiple criteria; vba-excelFind Column Name in Excel sheet if string matchesExcel 2010 VLOOKUP to match two columns and retrieve the MAX value from the third columnHow can we Vlookup Sheet1 data in sheet2 with partial match Columns CComparing two columns in one Excel sheet, to two columns in another sheet, and if they match, copy data from another columnFinding the right vlookup/index formula in excel to match weeks and datesPopulate VLOOKUP formula using VBA for all rows that have data in column AExcel Vba - How to copy and paste matched rows from one sheet to below exact matched rows in another sheet
Hot air balloons as primitive bombers
Was World War I a war of liberals against authoritarians?
Print last inputted byte
Turning a hard to access nut?
Does convergence of polynomials imply that of its coefficients?
Animating wave motion in water
UK Tourist Visa- Enquiry
Is there any common country to visit for uk and schengen visa?
When did hardware antialiasing start being available?
What is the tangent at a sharp point on a curve?
Have any astronauts/cosmonauts died in space?
Why does Surtur say that Thor is Asgard's doom?
Is "inadequate referencing" a euphemism for plagiarism?
Do I need to convey a moral for each of my blog post?
Do I need an EFI partition for each 18.04 ubuntu I have on my HD?
Should a narrator ever describe things based on a characters view instead of fact?
Pre-Employment Background Check With Consent For Future Checks
Have the tides ever turned twice on any open problem?
Why is this tree refusing to shed its dead leaves?
What is it called when someone votes for an option that's not their first choice?
10 year ban after applying for a UK student visa
What is the reasoning behind standardization (dividing by standard deviation)?
Exposing a company lying about themselves in a tightly knit industry: Is my career at risk on the long run?
CLI: Get information Ubuntu releases
Excel VBA: vLookup on a specific column in a Named Table and replacing value if it matches with multiple criteria and wildcard
2019 Community Moderator ElectionExcel formula for VLOOKUP with changing look-up value across all rows?Excel VBA that searches by header name not columnAlternative to wildcard searching for multiple criteria; vba-excelFind Column Name in Excel sheet if string matchesExcel 2010 VLOOKUP to match two columns and retrieve the MAX value from the third columnHow can we Vlookup Sheet1 data in sheet2 with partial match Columns CComparing two columns in one Excel sheet, to two columns in another sheet, and if they match, copy data from another columnFinding the right vlookup/index formula in excel to match weeks and datesPopulate VLOOKUP formula using VBA for all rows that have data in column AExcel Vba - How to copy and paste matched rows from one sheet to below exact matched rows in another sheet
I'd like to create a macro that will take the name of the resource and do a vLookup (or similar action) on another table to find the matching resource manager's info, then replace the NULL manager name and email address in the first table with the manager info that corresponds to that Resource. The end goal is to complete my table with the Generic Resource's manager and their email address.
I have a table on Sheet1 named "Resources":
"Resources" table
I also have a table on Sheet2 named "ManagerLookup":
"ManagerLookup" table
How can I loop through each Resource Name in my table to match the resources up with their correct manager? I'm only looking to replace the manager fields for which I have a match on the Resource Name. I can't only perform vlookup on rows with a "NULL" Manager name, since my data does not only use "NULL" for missing manager names (sometimes it's different).
I've searched for hours and can't find anything, but I need a clean way to do this. Also worth noting is that the "Resources" table doesn't ever get larger than about 500 rows so processing time is not a factor here. I'm using Excel 2016.
excel vba match
asked Mar 6 at 23:21
Adam JacksonAdam Jackson
813
add a comment |
I'd like to create a macro that will take the name of the resource and do a vLookup (or similar action) on another table to find the matching resource manager's info, then replace the NULL manager name and email address in the first table with the manager info that corresponds to that Resource. The end goal is to complete my table with the Generic Resource's manager and their email address.
I have a table on Sheet1 named "Resources":
"Resources" table
I also have a table on Sheet2 named "ManagerLookup":
"ManagerLookup" table
How can I loop through each Resource Name in my table to match the resources up with their correct manager? I'm only looking to replace the manager fields for which I have a match on the Resource Name. I can't only perform vlookup on rows with a "NULL" Manager name, since my data does not only use "NULL" for missing manager names (sometimes it's different).
I've searched for hours and can't find anything, but I need a clean way to do this. Also worth noting is that the "Resources" table doesn't ever get larger than about 500 rows so processing time is not a factor here. I'm using Excel 2016.
excel vba match
asked Mar 6 at 23:21
Adam JacksonAdam Jackson
813
2
Always best to include whatever code you've already tried, along with a description of what problem(s) you ran into.
– Tim Williams
Mar 6 at 23:39
add a comment |
I'd like to create a macro that will take the name of the resource and do a vLookup (or similar action) on another table to find the matching resource manager's info, then replace the NULL manager name and email address in the first table with the manager info that corresponds to that Resource. The end goal is to complete my table with the Generic Resource's manager and their email address.
I have a table on Sheet1 named "Resources":
"Resources" table
I also have a table on Sheet2 named "ManagerLookup":
"ManagerLookup" table
How can I loop through each Resource Name in my table to match the resources up with their correct manager? I'm only looking to replace the manager fields for which I have a match on the Resource Name. I can't only perform vlookup on rows with a "NULL" Manager name, since my data does not only use "NULL" for missing manager names (sometimes it's different).
I've searched for hours and can't find anything, but I need a clean way to do this. Also worth noting is that the "Resources" table doesn't ever get larger than about 500 rows so processing time is not a factor here. I'm using Excel 2016.
excel vba match
asked Mar 6 at 23:21
Adam JacksonAdam Jackson
813
I'd like to create a macro that will take the name of the resource and do a vLookup (or similar action) on another table to find the matching resource manager's info, then replace the NULL manager name and email address in the first table with the manager info that corresponds to that Resource. The end goal is to complete my table with the Generic Resource's manager and their email address.
I have a table on Sheet1 named "Resources":
"Resources" table
I also have a table on Sheet2 named "ManagerLookup":
"ManagerLookup" table
How can I loop through each Resource Name in my table to match the resources up with their correct manager? I'm only looking to replace the manager fields for which I have a match on the Resource Name. I can't only perform vlookup on rows with a "NULL" Manager name, since my data does not only use "NULL" for missing manager names (sometimes it's different).
I've searched for hours and can't find anything, but I need a clean way to do this. Also worth noting is that the "Resources" table doesn't ever get larger than about 500 rows so processing time is not a factor here. I'm using Excel 2016.
excel vba match
excel vba match
asked Mar 6 at 23:21
Adam JacksonAdam Jackson
813
asked Mar 6 at 23:21
Adam JacksonAdam Jackson
813
asked Mar 6 at 23:21
Adam JacksonAdam Jackson
813
asked Mar 6 at 23:21
Adam JacksonAdam Jackson
813
asked Mar 6 at 23:21
Adam JacksonAdam Jackson
813
813
2
Always best to include whatever code you've already tried, along with a description of what problem(s) you ran into.
– Tim Williams
Mar 6 at 23:39
add a comment |
2
Always best to include whatever code you've already tried, along with a description of what problem(s) you ran into.
– Tim Williams
Mar 6 at 23:39
2
2
Always best to include whatever code you've already tried, along with a description of what problem(s) you ran into.
– Tim Williams
Mar 6 at 23:39
Always best to include whatever code you've already tried, along with a description of what problem(s) you ran into.
– Tim Williams
Mar 6 at 23:39
add a comment |
1 Answer
1
active
oldest
votes
If the first 2 letters are unique to a manager like on your example, remove the # sign from the Managers table and on the resources table use the formula:
=IFERROR(VLOOKUP(LEFT(A2,2)&"*",Sheet2!A:B,2,FALSE),"Not found")
answered Mar 7 at 0:24
Ricardo ARicardo A
812314
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%2f55033748%2fexcel-vba-vlookup-on-a-specific-column-in-a-named-table-and-replacing-value-if%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
If the first 2 letters are unique to a manager like on your example, remove the # sign from the Managers table and on the resources table use the formula:
=IFERROR(VLOOKUP(LEFT(A2,2)&"*",Sheet2!A:B,2,FALSE),"Not found")
answered Mar 7 at 0:24
Ricardo ARicardo A
812314
add a comment |
If the first 2 letters are unique to a manager like on your example, remove the # sign from the Managers table and on the resources table use the formula:
=IFERROR(VLOOKUP(LEFT(A2,2)&"*",Sheet2!A:B,2,FALSE),"Not found")
answered Mar 7 at 0:24
Ricardo ARicardo A
812314
add a comment |
If the first 2 letters are unique to a manager like on your example, remove the # sign from the Managers table and on the resources table use the formula:
=IFERROR(VLOOKUP(LEFT(A2,2)&"*",Sheet2!A:B,2,FALSE),"Not found")
answered Mar 7 at 0:24
Ricardo ARicardo A
812314
If the first 2 letters are unique to a manager like on your example, remove the # sign from the Managers table and on the resources table use the formula:
=IFERROR(VLOOKUP(LEFT(A2,2)&"*",Sheet2!A:B,2,FALSE),"Not found")
answered Mar 7 at 0:24
Ricardo ARicardo A
812314
answered Mar 7 at 0:24
Ricardo ARicardo A
812314
answered Mar 7 at 0:24
Ricardo ARicardo A
812314
answered Mar 7 at 0:24
Ricardo ARicardo A
812314
812314
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%2f55033748%2fexcel-vba-vlookup-on-a-specific-column-in-a-named-table-and-replacing-value-if%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
2
Always best to include whatever code you've already tried, along with a description of what problem(s) you ran into.
– Tim Williams
Mar 6 at 23:39