Choose which file to vlookup from using if Announcing the arrival of Valued Associate #679:...
Can a party unilaterally change candidates in preparation for a General election?
Do I really need recursive chmod to restrict access to a folder?
Is it a good idea to use CNN to classify 1D signal?
Should I use a zero-interest credit card for a large one-time purchase?
What are the out-of-universe reasons for the references to Toby Maguire-era Spider-Man in ITSV
Is the Standard Deduction better than Itemized when both are the same amount?
Delete nth line from bottom
Is CEO the profession with the most psychopaths?
Why wasn't DOSKEY integrated with COMMAND.COM?
Wu formula for manifolds with boundary
Closed form of recurrent arithmetic series summation
2001: A Space Odyssey's use of the song "Daisy Bell" (Bicycle Built for Two); life imitates art or vice-versa?
Can a new player join a group only when a new campaign starts?
Why do we bend a book to keep it straight?
Is "Reachable Object" really an NP-complete problem?
How do I find out the mythology and history of my Fortress?
Using audio cues to encourage good posture
Significance of Cersei's obsession with elephants?
Extracting terms with certain heads in a function
Is it common practice to audition new musicians one-on-one before rehearsing with the entire band?
What's the meaning of "fortified infraction restraint"?
Is there a kind of relay only consumes power when switching?
Dating a Former Employee
Where are Serre’s lectures at Collège de France to be found?
Choose which file to vlookup from using if
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Randomize table guests in ExcelVLOOKUP Excel formula for multiple columsFormula =IF(VLOOKUP(…)=Cell;…) does not workMerge variable amount of rows in ExcelGetting #VALUE using VLOOKUP with mixed text and numbersUsing VLOOKUP to retrieve data in separate sheet based on valueVlookup help requestedMS Excel vlookup return only single instanceLookup a unique value in a matrixLookup if cell contains one of many options and vlookup the result
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I am trying to use an IF based vlookup, i.e. i have in one column list of trucks. In the other column I have a list of people who update certain data about those trucks in their own working files (say around 5 people). Each truck gets assigned to one person to update. They all have their own files but all files have the same template. Now i need to get, say, the dispatch date of a truck, but I need to use a IF based formula to choose which file to lookup from using the person's name. Is there an easier workaround for this? When I use IF this person, then vlookup this file, if this then vlookup this.. and so on and so forth.. the formula becomes huge. Especially if the number of persons become high.
microsoft-excel
asked 14 hours ago
Muhammad BadarMuhammad Badar
1
New contributor
Muhammad Badar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I am trying to use an IF based vlookup, i.e. i have in one column list of trucks. In the other column I have a list of people who update certain data about those trucks in their own working files (say around 5 people). Each truck gets assigned to one person to update. They all have their own files but all files have the same template. Now i need to get, say, the dispatch date of a truck, but I need to use a IF based formula to choose which file to lookup from using the person's name. Is there an easier workaround for this? When I use IF this person, then vlookup this file, if this then vlookup this.. and so on and so forth.. the formula becomes huge. Especially if the number of persons become high.
microsoft-excel
asked 14 hours ago
Muhammad BadarMuhammad Badar
1
New contributor
Muhammad Badar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
Welcome to Superuser! We don't write scripts/formulas if you show no effort of atleast trying. We're not a batch script service. Please do some research and edit your question to show what have you already tried.
– CaldeiraG
14 hours ago
add a comment |
I am trying to use an IF based vlookup, i.e. i have in one column list of trucks. In the other column I have a list of people who update certain data about those trucks in their own working files (say around 5 people). Each truck gets assigned to one person to update. They all have their own files but all files have the same template. Now i need to get, say, the dispatch date of a truck, but I need to use a IF based formula to choose which file to lookup from using the person's name. Is there an easier workaround for this? When I use IF this person, then vlookup this file, if this then vlookup this.. and so on and so forth.. the formula becomes huge. Especially if the number of persons become high.
microsoft-excel
asked 14 hours ago
Muhammad BadarMuhammad Badar
1
New contributor
Muhammad Badar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I am trying to use an IF based vlookup, i.e. i have in one column list of trucks. In the other column I have a list of people who update certain data about those trucks in their own working files (say around 5 people). Each truck gets assigned to one person to update. They all have their own files but all files have the same template. Now i need to get, say, the dispatch date of a truck, but I need to use a IF based formula to choose which file to lookup from using the person's name. Is there an easier workaround for this? When I use IF this person, then vlookup this file, if this then vlookup this.. and so on and so forth.. the formula becomes huge. Especially if the number of persons become high.
microsoft-excel
microsoft-excel
asked 14 hours ago
Muhammad BadarMuhammad Badar
1
New contributor
Muhammad Badar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 14 hours ago
Muhammad BadarMuhammad Badar
1
New contributor
Muhammad Badar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 14 hours ago
Muhammad BadarMuhammad Badar
1
New contributor
Muhammad Badar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 14 hours ago
Muhammad BadarMuhammad Badar
1
asked 14 hours ago
Muhammad BadarMuhammad Badar
1
1
New contributor
Muhammad Badar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Muhammad Badar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Muhammad Badar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
Welcome to Superuser! We don't write scripts/formulas if you show no effort of atleast trying. We're not a batch script service. Please do some research and edit your question to show what have you already tried.
– CaldeiraG
14 hours ago
add a comment |
1
Welcome to Superuser! We don't write scripts/formulas if you show no effort of atleast trying. We're not a batch script service. Please do some research and edit your question to show what have you already tried.
– CaldeiraG
14 hours ago
1
1
Welcome to Superuser! We don't write scripts/formulas if you show no effort of atleast trying. We're not a batch script service. Please do some research and edit your question to show what have you already tried.
– CaldeiraG
14 hours ago
Welcome to Superuser! We don't write scripts/formulas if you show no effort of atleast trying. We're not a batch script service. Please do some research and edit your question to show what have you already tried.
– CaldeiraG
14 hours ago
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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
});
}
});
Muhammad Badar is a new contributor. Be nice, and check out our Code of Conduct.
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%2fsuperuser.com%2fquestions%2f1426491%2fchoose-which-file-to-vlookup-from-using-if%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
Muhammad Badar is a new contributor. Be nice, and check out our Code of Conduct.
Muhammad Badar is a new contributor. Be nice, and check out our Code of Conduct.
Muhammad Badar is a new contributor. Be nice, and check out our Code of Conduct.
Muhammad Badar is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1426491%2fchoose-which-file-to-vlookup-from-using-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
1
Welcome to Superuser! We don't write scripts/formulas if you show no effort of atleast trying. We're not a batch script service. Please do some research and edit your question to show what have you already tried.
– CaldeiraG
14 hours ago