How do I make this Hlookup function work? Announcing the arrival of Valued Associate #679:...
Using "nakedly" instead of "with nothing on"
How can I make names more distinctive without making them longer?
When communicating altitude with a '9' in it, should it be pronounced "nine hundred" or "niner hundred"?
Why does tar appear to skip file contents when output file is /dev/null?
Direct Experience of Meditation
The following signatures were invalid: EXPKEYSIG 1397BC53640DB551
Can a monk deflect thrown melee weapons?
Do working physicists consider Newtonian mechanics to be "falsified"?
Did the new image of black hole confirm the general theory of relativity?
Mortgage adviser recommends a longer term than necessary combined with overpayments
What did Darwin mean by 'squib' here?
Estimate capacitor parameters
When is phishing education going too far?
Why use gamma over alpha radiation?
Active filter with series inductor and resistor - do these exist?
What LEGO pieces have "real-world" functionality?
Is drag coefficient lowest at zero angle of attack?
What do you call the holes in a flute?
Is it possible to ask for a hotel room without minibar/extra services?
What is the order of Mitzvot in Rambam's Sefer Hamitzvot?
How to say that you spent the night with someone, you were only sleeping and nothing else?
Why is there no army of Iron-Mans in the MCU?
Is above average number of years spent on PhD considered a red flag in future academia or industry positions?
What's the point in a preamp?
How do I make this Hlookup function work?
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)How to link to an Excel pivot table that will expand over time in Word 2007?Cut in excel doesn't work, and copying tables from one program to another returns textExcel - minifs function returning 0How to show the header and adjacent cell values of two lowest values in a row in Excel 2013Look up table values in different worksheets to create summary (VLOOKUP, HLOOKUP, INDIRECT)How to combine values from multiple rows into a single row? Have a module, but need the variables explainingWhat's VLOOKUP's true algorithm with range_lookup set to TRUE?How to find a particular index of a value that appears multiple times in a tableHLOOKUP: gives inaccurate data depending on the formula for lookup valueExcel function to calculate population in sub-regions
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I have been struggling with this problem for a couple of days, I do not see a problem with my function but it keeps showing N/A don't know why. I want to return population figures for each country in the second table starting from B7. Please help me understand my mistake. By the way, I am using the Russian version of Excel 2007 so in this case ЛОЖЬ=FALSE
microsoft-excel
edited 2 hours ago
Twisty Impersonator
18.8k1468101
asked yesterday
Hayk NazinyanHayk Nazinyan
1
New contributor
Hayk Nazinyan 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 have been struggling with this problem for a couple of days, I do not see a problem with my function but it keeps showing N/A don't know why. I want to return population figures for each country in the second table starting from B7. Please help me understand my mistake. By the way, I am using the Russian version of Excel 2007 so in this case ЛОЖЬ=FALSE
microsoft-excel
edited 2 hours ago
Twisty Impersonator
18.8k1468101
asked yesterday
Hayk NazinyanHayk Nazinyan
1
New contributor
Hayk Nazinyan 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 have been struggling with this problem for a couple of days, I do not see a problem with my function but it keeps showing N/A don't know why. I want to return population figures for each country in the second table starting from B7. Please help me understand my mistake. By the way, I am using the Russian version of Excel 2007 so in this case ЛОЖЬ=FALSE
microsoft-excel
edited 2 hours ago
Twisty Impersonator
18.8k1468101
asked yesterday
Hayk NazinyanHayk Nazinyan
1
New contributor
Hayk Nazinyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have been struggling with this problem for a couple of days, I do not see a problem with my function but it keeps showing N/A don't know why. I want to return population figures for each country in the second table starting from B7. Please help me understand my mistake. By the way, I am using the Russian version of Excel 2007 so in this case ЛОЖЬ=FALSE
microsoft-excel
microsoft-excel
edited 2 hours ago
Twisty Impersonator
18.8k1468101
asked yesterday
Hayk NazinyanHayk Nazinyan
1
New contributor
Hayk Nazinyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 2 hours ago
Twisty Impersonator
18.8k1468101
asked yesterday
Hayk NazinyanHayk Nazinyan
1
New contributor
Hayk Nazinyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 2 hours ago
Twisty Impersonator
18.8k1468101
edited 2 hours ago
Twisty Impersonator
18.8k1468101
edited 2 hours ago
Twisty Impersonator
18.8k1468101
18.8k1468101
asked yesterday
Hayk NazinyanHayk Nazinyan
1
New contributor
Hayk Nazinyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
Hayk NazinyanHayk Nazinyan
1
asked yesterday
Hayk NazinyanHayk Nazinyan
1
1
New contributor
Hayk Nazinyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Hayk Nazinyan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Hayk Nazinyan 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 |
add a comment |
1 Answer
1
active
oldest
votes
Verify that the search criteria (first argument) is equal to what you have in the list - also invisible / non printing characters "count", ...
... and if that doesn't help; verify that datatype settings are the same (select cell, hold CTRL hit 1) for the lookup array data and the cell with the first argument.
answered yesterday
HannuHannu
4,1851925
add a comment |
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
});
}
});
Hayk Nazinyan 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%2f1425020%2fhow-do-i-make-this-hlookup-function-work%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
Verify that the search criteria (first argument) is equal to what you have in the list - also invisible / non printing characters "count", ...
... and if that doesn't help; verify that datatype settings are the same (select cell, hold CTRL hit 1) for the lookup array data and the cell with the first argument.
answered yesterday
HannuHannu
4,1851925
add a comment |
Verify that the search criteria (first argument) is equal to what you have in the list - also invisible / non printing characters "count", ...
... and if that doesn't help; verify that datatype settings are the same (select cell, hold CTRL hit 1) for the lookup array data and the cell with the first argument.
answered yesterday
HannuHannu
4,1851925
add a comment |
Verify that the search criteria (first argument) is equal to what you have in the list - also invisible / non printing characters "count", ...
... and if that doesn't help; verify that datatype settings are the same (select cell, hold CTRL hit 1) for the lookup array data and the cell with the first argument.
answered yesterday
HannuHannu
4,1851925
Verify that the search criteria (first argument) is equal to what you have in the list - also invisible / non printing characters "count", ...
... and if that doesn't help; verify that datatype settings are the same (select cell, hold CTRL hit 1) for the lookup array data and the cell with the first argument.
answered yesterday
HannuHannu
4,1851925
answered yesterday
HannuHannu
4,1851925
answered yesterday
HannuHannu
4,1851925
answered yesterday
HannuHannu
4,1851925
4,1851925
add a comment |
add a comment |
Hayk Nazinyan is a new contributor. Be nice, and check out our Code of Conduct.
Hayk Nazinyan is a new contributor. Be nice, and check out our Code of Conduct.
Hayk Nazinyan is a new contributor. Be nice, and check out our Code of Conduct.
Hayk Nazinyan 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%2f1425020%2fhow-do-i-make-this-hlookup-function-work%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
