Display Value If It Does Not ExistVLOOKUP when Lookup Value is a cell populated via another formulaIn Excel...
Can a virus destroy the BIOS of a modern computer?
In the UK, is it possible to get a referendum by a court decision?
How does a dynamic QR code work?
Machine learning testing data
Does the Idaho Potato Commission associate potato skins with healthy eating?
How obscure is the use of 令 in 令和?
What Exploit Are These User Agents Trying to Use?
What reasons are there for a Capitalist to oppose a 100% inheritance tax?
Unlock My Phone! February 2018
How can saying a song's name be a copyright violation?
What exactly is ineptocracy?
Should I tell management that I intend to leave due to bad software development practices?
How could indestructible materials be used in power generation?
Did 'Cinema Songs' exist during Hiranyakshipu's time?
How dangerous is XSS
How exploitable/balanced is this homebrew spell: Spell Permanency?
How can a day be of 24 hours?
Was the Stack Exchange "Happy April Fools" page fitting with the '90's code?
What historical events would have to change in order to make 19th century "steampunk" technology possible?
Blending or harmonizing
Do Iron Man suits sport waste management systems?
Where would I need my direct neural interface to be implanted?
Can compressed videos be decoded back to their uncompresed original format?
Finitely generated matrix groups whose eigenvalues are all algebraic
Display Value If It Does Not Exist
VLOOKUP when Lookup Value is a cell populated via another formulaIn Excel 2007 does the data from a formula referenced in another cell get used, or the formula itself?Excel lookup / value formulaVlookup not registering range changes in calculationExcel Formula to autopopulate a cell and mark as AssignedHow to populate information from one sheet to another in Excel Workbook?vlookup increment by a fixed numberExcel how to insert data based upon criteriaUSING AVERAGEIFS with value >VLOOKUP, If exists use other value
I am trying to populate a cell based on two criteria and this works using the following code:
=INDEX(config!H2:H20,
MATCH(1,
(F4=config!F2:F20)*(VLOOKUP(D4,config!C2:D20,2,FALSE)=config!G2:G20),0))
Sheet1:
As you can see the column E2,E3,E4 are populated as a test. However, you can see it's populating with number 7 twice - which is correct based on the current formula. Although, I want the formula to do a check if the value exists in column E, then to use the next number based on the criteria.
config:
Therefore, in cell E7, it should display the value "8" - coming from sheet config, cell H9 (based on Pete's "DM DI" value equals "Yes" from the config sheet, so Room Di must be "Yes"... and Minor from sheet1 cell F4 is yes, so config sheet must have Room minor value as Yes too.
microsoft-excel worksheet-function
asked 2 hours ago
user1472266user1472266
1255
add a comment |
I am trying to populate a cell based on two criteria and this works using the following code:
=INDEX(config!H2:H20,
MATCH(1,
(F4=config!F2:F20)*(VLOOKUP(D4,config!C2:D20,2,FALSE)=config!G2:G20),0))
Sheet1:
As you can see the column E2,E3,E4 are populated as a test. However, you can see it's populating with number 7 twice - which is correct based on the current formula. Although, I want the formula to do a check if the value exists in column E, then to use the next number based on the criteria.
config:
Therefore, in cell E7, it should display the value "8" - coming from sheet config, cell H9 (based on Pete's "DM DI" value equals "Yes" from the config sheet, so Room Di must be "Yes"... and Minor from sheet1 cell F4 is yes, so config sheet must have Room minor value as Yes too.
microsoft-excel worksheet-function
asked 2 hours ago
user1472266user1472266
1255
add a comment |
I am trying to populate a cell based on two criteria and this works using the following code:
=INDEX(config!H2:H20,
MATCH(1,
(F4=config!F2:F20)*(VLOOKUP(D4,config!C2:D20,2,FALSE)=config!G2:G20),0))
Sheet1:
As you can see the column E2,E3,E4 are populated as a test. However, you can see it's populating with number 7 twice - which is correct based on the current formula. Although, I want the formula to do a check if the value exists in column E, then to use the next number based on the criteria.
config:
Therefore, in cell E7, it should display the value "8" - coming from sheet config, cell H9 (based on Pete's "DM DI" value equals "Yes" from the config sheet, so Room Di must be "Yes"... and Minor from sheet1 cell F4 is yes, so config sheet must have Room minor value as Yes too.
microsoft-excel worksheet-function
asked 2 hours ago
user1472266user1472266
1255
I am trying to populate a cell based on two criteria and this works using the following code:
=INDEX(config!H2:H20,
MATCH(1,
(F4=config!F2:F20)*(VLOOKUP(D4,config!C2:D20,2,FALSE)=config!G2:G20),0))
Sheet1:
As you can see the column E2,E3,E4 are populated as a test. However, you can see it's populating with number 7 twice - which is correct based on the current formula. Although, I want the formula to do a check if the value exists in column E, then to use the next number based on the criteria.
config:
Therefore, in cell E7, it should display the value "8" - coming from sheet config, cell H9 (based on Pete's "DM DI" value equals "Yes" from the config sheet, so Room Di must be "Yes"... and Minor from sheet1 cell F4 is yes, so config sheet must have Room minor value as Yes too.
microsoft-excel worksheet-function
microsoft-excel worksheet-function
asked 2 hours ago
user1472266user1472266
1255
asked 2 hours ago
user1472266user1472266
1255
asked 2 hours ago
user1472266user1472266
1255
asked 2 hours ago
user1472266user1472266
1255
asked 2 hours ago
user1472266user1472266
1255
1255
add a comment |
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
});
}
});
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%2f1420614%2fdisplay-value-if-it-does-not-exist%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 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%2f1420614%2fdisplay-value-if-it-does-not-exist%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
