Using a vlookup in a Sumifs formula on a tableTrouble getting VLOOKUP to workvlookup and indirect and...
Is there a verb that means to inject with poison?
What makes papers publishable in top-tier journals?
Count repetitions of an array
Potential client has a problematic employee I can't work with
How vim overwrites readonly mode?
How to not let the Identify spell spoil everything?
What species should be used for storage of human minds?
Coworker asking me to not bring cakes due to self control issue. What should I do?
Why did Luke use his left hand to shoot?
How does Leonard in "Memento" remember reading and writing?
Which RAF squadrons and aircraft types took part in the bombing of Berlin on the 25th of August 1940?
How can I play a serial killer in a party of good PCs?
Why zero tolerance on nudity in space?
Is there a way to not have to poll the UART of an AVR?
What's the oldest plausible frozen specimen for a Jurassic Park style story-line?
A Missing Symbol for This Logo
Does Skippy chunky peanut butter contain trans fat?
Why is the size of a directory either 0 or 4096?
How is it possible that the folder is there yet isnt in the same time?
How can the probability of a fumble decrease linearly with more dice?
Equivalent of "illegal" for violating civil law
Am I correct in stating that the study of topology is purely theoretical?
A starship is travelling at 0.9c and collides with a small rock. Will it leave a clean hole through, or will more happen?
Why is a temp table a more efficient solution to the Halloween Problem than an eager spool?
Using a vlookup in a Sumifs formula on a table
Trouble getting VLOOKUP to workvlookup and indirect and external shared workbooksvlookup in a cell that contains mid formulaExcel 2013, Vlookup - accessing different sheets.within a workbookHow can I return a count of a specific criteria in a range of duplicated items?using named ranges in a sumif formulaPartial vlookup between two columns and two different worksheetsExcel 2010 : vlookup - How to create a column automatically?Excel - Filter table from one sheet to another using formulaExcel Vlookup assistance
I have a table called Popular_Pages which has columns/metrics Users, Sessions, Page Views etc.I have created a dropdown to select which metric to view based on the columns, this dropdown is based on a list in the sheet next to each metric I have the actual call for the table, e.g. Users then [Users]
If I write the formula;
=count(popular_pages[Users])
I get the correct answer, however, if I write the formula;
=count("popular_pages"&VLOOKUP(U13,Settings!$C$65:$E$69,3,FALSE)
Where U13 is the dropdown and contains "Users" and the range C65:E69 looks like this, returning [Users]
Metric-------------|-------Heading------- | Column Name
Page Views-----|------------1------------ | [Page Views]
Users-------------|------------ 2----------- | [Users]
Sessions---------|----------- 3------------ | [Sessions]
..
..
it does not work I get the standard there is an error in your formula message.
microsoft-excel worksheet-function
asked 3 mins ago
NazNaz
1158
add a comment |
I have a table called Popular_Pages which has columns/metrics Users, Sessions, Page Views etc.I have created a dropdown to select which metric to view based on the columns, this dropdown is based on a list in the sheet next to each metric I have the actual call for the table, e.g. Users then [Users]
If I write the formula;
=count(popular_pages[Users])
I get the correct answer, however, if I write the formula;
=count("popular_pages"&VLOOKUP(U13,Settings!$C$65:$E$69,3,FALSE)
Where U13 is the dropdown and contains "Users" and the range C65:E69 looks like this, returning [Users]
Metric-------------|-------Heading------- | Column Name
Page Views-----|------------1------------ | [Page Views]
Users-------------|------------ 2----------- | [Users]
Sessions---------|----------- 3------------ | [Sessions]
..
..
it does not work I get the standard there is an error in your formula message.
microsoft-excel worksheet-function
asked 3 mins ago
NazNaz
1158
add a comment |
I have a table called Popular_Pages which has columns/metrics Users, Sessions, Page Views etc.I have created a dropdown to select which metric to view based on the columns, this dropdown is based on a list in the sheet next to each metric I have the actual call for the table, e.g. Users then [Users]
If I write the formula;
=count(popular_pages[Users])
I get the correct answer, however, if I write the formula;
=count("popular_pages"&VLOOKUP(U13,Settings!$C$65:$E$69,3,FALSE)
Where U13 is the dropdown and contains "Users" and the range C65:E69 looks like this, returning [Users]
Metric-------------|-------Heading------- | Column Name
Page Views-----|------------1------------ | [Page Views]
Users-------------|------------ 2----------- | [Users]
Sessions---------|----------- 3------------ | [Sessions]
..
..
it does not work I get the standard there is an error in your formula message.
microsoft-excel worksheet-function
asked 3 mins ago
NazNaz
1158
I have a table called Popular_Pages which has columns/metrics Users, Sessions, Page Views etc.I have created a dropdown to select which metric to view based on the columns, this dropdown is based on a list in the sheet next to each metric I have the actual call for the table, e.g. Users then [Users]
If I write the formula;
=count(popular_pages[Users])
I get the correct answer, however, if I write the formula;
=count("popular_pages"&VLOOKUP(U13,Settings!$C$65:$E$69,3,FALSE)
Where U13 is the dropdown and contains "Users" and the range C65:E69 looks like this, returning [Users]
Metric-------------|-------Heading------- | Column Name
Page Views-----|------------1------------ | [Page Views]
Users-------------|------------ 2----------- | [Users]
Sessions---------|----------- 3------------ | [Sessions]
..
..
it does not work I get the standard there is an error in your formula message.
microsoft-excel worksheet-function
microsoft-excel worksheet-function
asked 3 mins ago
NazNaz
1158
asked 3 mins ago
NazNaz
1158
asked 3 mins ago
NazNaz
1158
asked 3 mins ago
NazNaz
1158
asked 3 mins ago
NazNaz
1158
1158
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%2f1409528%2fusing-a-vlookup-in-a-sumifs-formula-on-a-table%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%2f1409528%2fusing-a-vlookup-in-a-sumifs-formula-on-a-table%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
