Google Sheets trying to match data from two columns on another tab2019 Community Moderator ElectionMultiple results from index-match on Google SheetsMatching and sorting data from another sheetLookup data based on drop down and secondary column google sheetsHow to do two-column lookup to produce summary? (Google sheets)Google Sheets copy between columns based on match?Google Spreadsheet : How to feed two sheets into a single pivot table?Assign column header to each data in the table and create a table with two column (Google Sheet)Google Script, find match value from one column with another columnReference cell to another sheet cell which has array formula?Google Sheets: Count If Matching items in same column
My adviser wants to be the first author
Why does Bach not break the rules here?
Are there other languages, besides English, where the indefinite (or definite) article varies based on sound?
Is it true that good novels will automatically sell themselves on Amazon (and so on) and there is no need for one to waste time promoting?
Opacity of an object in 2.8
In a future war, an old lady is trying to raise a boy but one of the weapons has made everyone deaf
Unexpected result from ArcLength
Hacking a Safe Lock after 3 tries
What are the naunces between the use of 訊く instead of 聞く in the following sentence?
It's a yearly task, alright
Why did it take so long to abandon sail after steamships were demonstrated?
What options are left, if Britain cannot decide?
Time travel from stationary position?
If I can solve Sudoku can I solve Travelling Salesman Problem(TSP)? If yes, how?
Why would a flight no longer considered airworthy be redirected like this?
How to write cleanly even if my character uses expletive language?
What approach do we need to follow for projects without a test environment?
Why doesn't the EU now just force the UK to choose between referendum and no-deal?
What is the significance behind "40 days" that often appears in the Bible?
A Cautionary Suggestion
Most cost effective thermostat setting: consistent temperature vs. lowest temperature possible
Professor being mistaken for a grad student
How Could an Airship Be Repaired Mid-Flight
Sailing the cryptic seas
Google Sheets trying to match data from two columns on another tab
2019 Community Moderator ElectionMultiple results from index-match on Google SheetsMatching and sorting data from another sheetLookup data based on drop down and secondary column google sheetsHow to do two-column lookup to produce summary? (Google sheets)Google Sheets copy between columns based on match?Google Spreadsheet : How to feed two sheets into a single pivot table?Assign column header to each data in the table and create a table with two column (Google Sheet)Google Script, find match value from one column with another columnReference cell to another sheet cell which has array formula?Google Sheets: Count If Matching items in same column
I have a formula that works as long as all the data it is trying to match from is in Column A. I need this to also look at the data in column B to see if it matches. I also have another formula that matches two different columns and I also need it to look in both A and B for the data. Both of these are used for conditional formatting. Can anyone help me set these up so it is looking on the Received tab in both columns A and B?
Current formulas that work:
=match($C:$C, indirect("Received!A2:A"),0)
=and(match($I:$I, indirect("Received!A2:A"),0), (match($O:$O, indirect("Received!A2:A"),0)))
What I am trying to do but is not working:
=match($C:$C, indirect("Received!A2:B"),0)
=and(match($I:$I, indirect("Received!A2:B"),0), (match($O:$O, indirect("Received!A2:B"),0)))
Test Doc: https://docs.google.com/spreadsheets/d/1dDrmASkiy4KY8ywVuBLdZzAZtvyTohJBFFWtSte5g8A/edit?usp=sharing
google-sheets google-sheets-formula
asked Mar 6 at 19:54
Raymond Kowalski IIIRaymond Kowalski III
11
add a comment |
I have a formula that works as long as all the data it is trying to match from is in Column A. I need this to also look at the data in column B to see if it matches. I also have another formula that matches two different columns and I also need it to look in both A and B for the data. Both of these are used for conditional formatting. Can anyone help me set these up so it is looking on the Received tab in both columns A and B?
Current formulas that work:
=match($C:$C, indirect("Received!A2:A"),0)
=and(match($I:$I, indirect("Received!A2:A"),0), (match($O:$O, indirect("Received!A2:A"),0)))
What I am trying to do but is not working:
=match($C:$C, indirect("Received!A2:B"),0)
=and(match($I:$I, indirect("Received!A2:B"),0), (match($O:$O, indirect("Received!A2:B"),0)))
Test Doc: https://docs.google.com/spreadsheets/d/1dDrmASkiy4KY8ywVuBLdZzAZtvyTohJBFFWtSte5g8A/edit?usp=sharing
google-sheets google-sheets-formula
asked Mar 6 at 19:54
Raymond Kowalski IIIRaymond Kowalski III
11
can you share a copy of your sheet?
– player0
Mar 6 at 20:04
add a comment |
I have a formula that works as long as all the data it is trying to match from is in Column A. I need this to also look at the data in column B to see if it matches. I also have another formula that matches two different columns and I also need it to look in both A and B for the data. Both of these are used for conditional formatting. Can anyone help me set these up so it is looking on the Received tab in both columns A and B?
Current formulas that work:
=match($C:$C, indirect("Received!A2:A"),0)
=and(match($I:$I, indirect("Received!A2:A"),0), (match($O:$O, indirect("Received!A2:A"),0)))
What I am trying to do but is not working:
=match($C:$C, indirect("Received!A2:B"),0)
=and(match($I:$I, indirect("Received!A2:B"),0), (match($O:$O, indirect("Received!A2:B"),0)))
Test Doc: https://docs.google.com/spreadsheets/d/1dDrmASkiy4KY8ywVuBLdZzAZtvyTohJBFFWtSte5g8A/edit?usp=sharing
google-sheets google-sheets-formula
asked Mar 6 at 19:54
Raymond Kowalski IIIRaymond Kowalski III
11
I have a formula that works as long as all the data it is trying to match from is in Column A. I need this to also look at the data in column B to see if it matches. I also have another formula that matches two different columns and I also need it to look in both A and B for the data. Both of these are used for conditional formatting. Can anyone help me set these up so it is looking on the Received tab in both columns A and B?
Current formulas that work:
=match($C:$C, indirect("Received!A2:A"),0)
=and(match($I:$I, indirect("Received!A2:A"),0), (match($O:$O, indirect("Received!A2:A"),0)))
What I am trying to do but is not working:
=match($C:$C, indirect("Received!A2:B"),0)
=and(match($I:$I, indirect("Received!A2:B"),0), (match($O:$O, indirect("Received!A2:B"),0)))
Test Doc: https://docs.google.com/spreadsheets/d/1dDrmASkiy4KY8ywVuBLdZzAZtvyTohJBFFWtSte5g8A/edit?usp=sharing
google-sheets google-sheets-formula
google-sheets google-sheets-formula
asked Mar 6 at 19:54
Raymond Kowalski IIIRaymond Kowalski III
11
asked Mar 6 at 19:54
Raymond Kowalski IIIRaymond Kowalski III
11
edited Mar 7 at 14:56
Raymond Kowalski III
asked Mar 6 at 19:54
Raymond Kowalski IIIRaymond Kowalski III
11
asked Mar 6 at 19:54
Raymond Kowalski IIIRaymond Kowalski III
11
asked Mar 6 at 19:54
Raymond Kowalski IIIRaymond Kowalski III
11
11
can you share a copy of your sheet?
– player0
Mar 6 at 20:04
add a comment |
can you share a copy of your sheet?
– player0
Mar 6 at 20:04
can you share a copy of your sheet?
– player0
Mar 6 at 20:04
can you share a copy of your sheet?
– player0
Mar 6 at 20:04
add a comment |
1 Answer
1
active
oldest
votes
try:
=OR(MATCH($C:$C,INDIRECT("Received!A2:A"),0),MATCH($C:$C,INDIRECT("Received!B2:B"),0))
and:
=OR(AND(MATCH($I:$I,INDIRECT("Received!A2:A"),0),(MATCH($O:$O,INDIRECT("Received!A2:A"),0))),
AND(MATCH($I:$I,INDIRECT("Received!B2:B"),0),(MATCH($O:$O,INDIRECT("Received!B2:B"),0))))
answered Mar 6 at 20:10
player0player0
5,44341232
Sorry, it does not appear to be working. I have added a link to a test sheet for you to see.
– Raymond Kowalski III
Mar 7 at 14:56
add a comment |
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%2f55031209%2fgoogle-sheets-trying-to-match-data-from-two-columns-on-another-tab%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
try:
=OR(MATCH($C:$C,INDIRECT("Received!A2:A"),0),MATCH($C:$C,INDIRECT("Received!B2:B"),0))
and:
=OR(AND(MATCH($I:$I,INDIRECT("Received!A2:A"),0),(MATCH($O:$O,INDIRECT("Received!A2:A"),0))),
AND(MATCH($I:$I,INDIRECT("Received!B2:B"),0),(MATCH($O:$O,INDIRECT("Received!B2:B"),0))))
answered Mar 6 at 20:10
player0player0
5,44341232
Sorry, it does not appear to be working. I have added a link to a test sheet for you to see.
– Raymond Kowalski III
Mar 7 at 14:56
add a comment |
try:
=OR(MATCH($C:$C,INDIRECT("Received!A2:A"),0),MATCH($C:$C,INDIRECT("Received!B2:B"),0))
and:
=OR(AND(MATCH($I:$I,INDIRECT("Received!A2:A"),0),(MATCH($O:$O,INDIRECT("Received!A2:A"),0))),
AND(MATCH($I:$I,INDIRECT("Received!B2:B"),0),(MATCH($O:$O,INDIRECT("Received!B2:B"),0))))
answered Mar 6 at 20:10
player0player0
5,44341232
Sorry, it does not appear to be working. I have added a link to a test sheet for you to see.
– Raymond Kowalski III
Mar 7 at 14:56
add a comment |
try:
=OR(MATCH($C:$C,INDIRECT("Received!A2:A"),0),MATCH($C:$C,INDIRECT("Received!B2:B"),0))
and:
=OR(AND(MATCH($I:$I,INDIRECT("Received!A2:A"),0),(MATCH($O:$O,INDIRECT("Received!A2:A"),0))),
AND(MATCH($I:$I,INDIRECT("Received!B2:B"),0),(MATCH($O:$O,INDIRECT("Received!B2:B"),0))))
answered Mar 6 at 20:10
player0player0
5,44341232
try:
=OR(MATCH($C:$C,INDIRECT("Received!A2:A"),0),MATCH($C:$C,INDIRECT("Received!B2:B"),0))
and:
=OR(AND(MATCH($I:$I,INDIRECT("Received!A2:A"),0),(MATCH($O:$O,INDIRECT("Received!A2:A"),0))),
AND(MATCH($I:$I,INDIRECT("Received!B2:B"),0),(MATCH($O:$O,INDIRECT("Received!B2:B"),0))))
answered Mar 6 at 20:10
player0player0
5,44341232
answered Mar 6 at 20:10
player0player0
5,44341232
answered Mar 6 at 20:10
player0player0
5,44341232
answered Mar 6 at 20:10
player0player0
5,44341232
5,44341232
Sorry, it does not appear to be working. I have added a link to a test sheet for you to see.
– Raymond Kowalski III
Mar 7 at 14:56
add a comment |
Sorry, it does not appear to be working. I have added a link to a test sheet for you to see.
– Raymond Kowalski III
Mar 7 at 14:56
Sorry, it does not appear to be working. I have added a link to a test sheet for you to see.
– Raymond Kowalski III
Mar 7 at 14:56
Sorry, it does not appear to be working. I have added a link to a test sheet for you to see.
– Raymond Kowalski III
Mar 7 at 14:56
add a comment |
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%2f55031209%2fgoogle-sheets-trying-to-match-data-from-two-columns-on-another-tab%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
can you share a copy of your sheet?
– player0
Mar 6 at 20:04