Excel Returning String from different sheet2019 Community Moderator ElectionHow to create Excel (.XLS and .XLSX) file in C# without installing Ms Office?Import a single Excel cell into SSISExcel dynamic hyperlink sheet navigationHow can I join data from 2 different excel sheets based on one common row?Auto fill additional sheets from a main sheet in Excel 2010Build table in Excel By Pulling Data from Different SheetsCopying Cell formatting from a different sheet Excel VBAPopulate cells in Excel with text from another sheetExcel VBA - Repeating Cell Range in different sheetxlswrite many cell arrays into Excel as seperate named sheets
Synchronized implementation of a bank account in Java
Does the attack bonus from a Masterwork weapon stack with the attack bonus from Masterwork ammunition?
Do I need to be arrogant to get ahead?
Print last inputted byte
What is the significance behind "40 days" that often appears in the Bible?
Geography in 3D perspective
Do native speakers use "ultima" and "proxima" frequently in spoken English?
Can you move over difficult terrain with only 5 feet of movement?
What exactly term 'companion plants' means?
How to define limit operations in general topological spaces? Are nets able to do this?
Why is indicated airspeed rather than ground speed used during the takeoff roll?
Writing in a Christian voice
Is honey really a supersaturated solution? Does heating to un-crystalize redissolve it or melt it?
Is there a creature that is resistant or immune to non-magical damage other than bludgeoning, slashing, and piercing?
Are dual Irish/British citizens bound by the 90/180 day rule when travelling in the EU after Brexit?
Describing a chess game in a novel
Unfrosted light bulb
How are passwords stolen from companies if they only store hashes?
How do hiring committees for research positions view getting "scooped"?
Maths symbols and unicode-math input inside siunitx commands
Print a physical multiplication table
Worshiping one God at a time?
Brake pads destroying wheels
What favor did Moody owe Dumbledore?
Excel Returning String from different sheet
2019 Community Moderator ElectionHow to create Excel (.XLS and .XLSX) file in C# without installing Ms Office?Import a single Excel cell into SSISExcel dynamic hyperlink sheet navigationHow can I join data from 2 different excel sheets based on one common row?Auto fill additional sheets from a main sheet in Excel 2010Build table in Excel By Pulling Data from Different SheetsCopying Cell formatting from a different sheet Excel VBAPopulate cells in Excel with text from another sheetExcel VBA - Repeating Cell Range in different sheetxlswrite many cell arrays into Excel as seperate named sheets
In Sheet 1 I have five tables for different items sold.
I have it set up right now that I can type the part number into A1 and it will bring all of the data associated with that part/row.
My problem is A3, I want it to reference the tables name depending on what part I type in.
I originally had an IF function seeing if the Part name I entered was between two cell numbers but that wasn't working when I kept changing the Part I was looking up.
Is there a way to return a single string from 5 different strings depending on where a separate string it located within another sheet?
excel
edited Mar 6 at 22:14
Scott Craner
92.6k82652
asked Mar 6 at 22:12
Aaron WAaron W
1
add a comment |
In Sheet 1 I have five tables for different items sold.
I have it set up right now that I can type the part number into A1 and it will bring all of the data associated with that part/row.
My problem is A3, I want it to reference the tables name depending on what part I type in.
I originally had an IF function seeing if the Part name I entered was between two cell numbers but that wasn't working when I kept changing the Part I was looking up.
Is there a way to return a single string from 5 different strings depending on where a separate string it located within another sheet?
excel
edited Mar 6 at 22:14
Scott Craner
92.6k82652
asked Mar 6 at 22:12
Aaron WAaron W
1
You will need to spell out the exact logic you'd want to use...
– Tim Williams
Mar 6 at 22:34
Are your tables side by side and the partnumbers are on the y-axis?
– Alex de Jong
Mar 6 at 22:37
Part numbers go Y-Axis. X-Axis has categories for the prices, number, and description. The tables are just stacked, so the part numbers go from A2:A420 with breaks for the new table names.
– Aaron W
Mar 6 at 22:46
Logic goes: Type part number into A1 then A3 returns the category the part falls under (which would be the table title).
– Aaron W
Mar 6 at 22:52
Figured it out, just went an easier route of having 5 hidden boxes running IF statements checking the conditions then made A3 check those 5 boxes and returned a value based on which one returned a 'Yes' response.
– Aaron W
Mar 7 at 19:23
add a comment |
In Sheet 1 I have five tables for different items sold.
I have it set up right now that I can type the part number into A1 and it will bring all of the data associated with that part/row.
My problem is A3, I want it to reference the tables name depending on what part I type in.
I originally had an IF function seeing if the Part name I entered was between two cell numbers but that wasn't working when I kept changing the Part I was looking up.
Is there a way to return a single string from 5 different strings depending on where a separate string it located within another sheet?
excel
edited Mar 6 at 22:14
Scott Craner
92.6k82652
asked Mar 6 at 22:12
Aaron WAaron W
1
In Sheet 1 I have five tables for different items sold.
I have it set up right now that I can type the part number into A1 and it will bring all of the data associated with that part/row.
My problem is A3, I want it to reference the tables name depending on what part I type in.
I originally had an IF function seeing if the Part name I entered was between two cell numbers but that wasn't working when I kept changing the Part I was looking up.
Is there a way to return a single string from 5 different strings depending on where a separate string it located within another sheet?
excel
excel
edited Mar 6 at 22:14
Scott Craner
92.6k82652
asked Mar 6 at 22:12
Aaron WAaron W
1
edited Mar 6 at 22:14
Scott Craner
92.6k82652
asked Mar 6 at 22:12
Aaron WAaron W
1
edited Mar 6 at 22:14
Scott Craner
92.6k82652
edited Mar 6 at 22:14
Scott Craner
92.6k82652
edited Mar 6 at 22:14
Scott Craner
92.6k82652
92.6k82652
asked Mar 6 at 22:12
Aaron WAaron W
1
asked Mar 6 at 22:12
Aaron WAaron W
1
asked Mar 6 at 22:12
Aaron WAaron W
1
1
You will need to spell out the exact logic you'd want to use...
– Tim Williams
Mar 6 at 22:34
Are your tables side by side and the partnumbers are on the y-axis?
– Alex de Jong
Mar 6 at 22:37
Part numbers go Y-Axis. X-Axis has categories for the prices, number, and description. The tables are just stacked, so the part numbers go from A2:A420 with breaks for the new table names.
– Aaron W
Mar 6 at 22:46
Logic goes: Type part number into A1 then A3 returns the category the part falls under (which would be the table title).
– Aaron W
Mar 6 at 22:52
Figured it out, just went an easier route of having 5 hidden boxes running IF statements checking the conditions then made A3 check those 5 boxes and returned a value based on which one returned a 'Yes' response.
– Aaron W
Mar 7 at 19:23
add a comment |
You will need to spell out the exact logic you'd want to use...
– Tim Williams
Mar 6 at 22:34
Are your tables side by side and the partnumbers are on the y-axis?
– Alex de Jong
Mar 6 at 22:37
Part numbers go Y-Axis. X-Axis has categories for the prices, number, and description. The tables are just stacked, so the part numbers go from A2:A420 with breaks for the new table names.
– Aaron W
Mar 6 at 22:46
Logic goes: Type part number into A1 then A3 returns the category the part falls under (which would be the table title).
– Aaron W
Mar 6 at 22:52
Figured it out, just went an easier route of having 5 hidden boxes running IF statements checking the conditions then made A3 check those 5 boxes and returned a value based on which one returned a 'Yes' response.
– Aaron W
Mar 7 at 19:23
You will need to spell out the exact logic you'd want to use...
– Tim Williams
Mar 6 at 22:34
You will need to spell out the exact logic you'd want to use...
– Tim Williams
Mar 6 at 22:34
Are your tables side by side and the partnumbers are on the y-axis?
– Alex de Jong
Mar 6 at 22:37
Are your tables side by side and the partnumbers are on the y-axis?
– Alex de Jong
Mar 6 at 22:37
Part numbers go Y-Axis. X-Axis has categories for the prices, number, and description. The tables are just stacked, so the part numbers go from A2:A420 with breaks for the new table names.
– Aaron W
Mar 6 at 22:46
Part numbers go Y-Axis. X-Axis has categories for the prices, number, and description. The tables are just stacked, so the part numbers go from A2:A420 with breaks for the new table names.
– Aaron W
Mar 6 at 22:46
Logic goes: Type part number into A1 then A3 returns the category the part falls under (which would be the table title).
– Aaron W
Mar 6 at 22:52
Logic goes: Type part number into A1 then A3 returns the category the part falls under (which would be the table title).
– Aaron W
Mar 6 at 22:52
Figured it out, just went an easier route of having 5 hidden boxes running IF statements checking the conditions then made A3 check those 5 boxes and returned a value based on which one returned a 'Yes' response.
– Aaron W
Mar 7 at 19:23
Figured it out, just went an easier route of having 5 hidden boxes running IF statements checking the conditions then made A3 check those 5 boxes and returned a value based on which one returned a 'Yes' response.
– Aaron W
Mar 7 at 19:23
add a comment |
0
active
oldest
votes
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%2f55033001%2fexcel-returning-string-from-different-sheet%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 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%2f55033001%2fexcel-returning-string-from-different-sheet%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
You will need to spell out the exact logic you'd want to use...
– Tim Williams
Mar 6 at 22:34
Are your tables side by side and the partnumbers are on the y-axis?
– Alex de Jong
Mar 6 at 22:37
Part numbers go Y-Axis. X-Axis has categories for the prices, number, and description. The tables are just stacked, so the part numbers go from A2:A420 with breaks for the new table names.
– Aaron W
Mar 6 at 22:46
Logic goes: Type part number into A1 then A3 returns the category the part falls under (which would be the table title).
– Aaron W
Mar 6 at 22:52
Figured it out, just went an easier route of having 5 hidden boxes running IF statements checking the conditions then made A3 check those 5 boxes and returned a value based on which one returned a 'Yes' response.
– Aaron W
Mar 7 at 19:23