Returning row and column value in a large chart if column is in a range
up vote
0
down vote
favorite
This is for a wastewater oxygen saturation chart used in determining Biochemical Oxygen Demand values.
I want to find the intersection value returned to a cell of my choosing. But the catch is that the column values are in a range from the column farthest out value is the low number, to the previous column value being the lowest range to jump into the next column of values.
I've tried VLOOKUP, coupled with INDEX / MATCH, and I still can't seem to get a handle on this.
microsoft-excel microsoft-excel-2010 charts
edited 5 hours ago
Albin
2,295828
asked 6 hours ago
Orin Huff
1
New contributor
Orin Huff 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 |
up vote
0
down vote
favorite
This is for a wastewater oxygen saturation chart used in determining Biochemical Oxygen Demand values.
I want to find the intersection value returned to a cell of my choosing. But the catch is that the column values are in a range from the column farthest out value is the low number, to the previous column value being the lowest range to jump into the next column of values.
I've tried VLOOKUP, coupled with INDEX / MATCH, and I still can't seem to get a handle on this.
microsoft-excel microsoft-excel-2010 charts
edited 5 hours ago
Albin
2,295828
asked 6 hours ago
Orin Huff
1
New contributor
Orin Huff 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 |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
This is for a wastewater oxygen saturation chart used in determining Biochemical Oxygen Demand values.
I want to find the intersection value returned to a cell of my choosing. But the catch is that the column values are in a range from the column farthest out value is the low number, to the previous column value being the lowest range to jump into the next column of values.
I've tried VLOOKUP, coupled with INDEX / MATCH, and I still can't seem to get a handle on this.
microsoft-excel microsoft-excel-2010 charts
edited 5 hours ago
Albin
2,295828
asked 6 hours ago
Orin Huff
1
New contributor
Orin Huff is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
This is for a wastewater oxygen saturation chart used in determining Biochemical Oxygen Demand values.
I want to find the intersection value returned to a cell of my choosing. But the catch is that the column values are in a range from the column farthest out value is the low number, to the previous column value being the lowest range to jump into the next column of values.
I've tried VLOOKUP, coupled with INDEX / MATCH, and I still can't seem to get a handle on this.
microsoft-excel microsoft-excel-2010 charts
microsoft-excel microsoft-excel-2010 charts
edited 5 hours ago
Albin
2,295828
asked 6 hours ago
Orin Huff
1
New contributor
Orin Huff is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 5 hours ago
Albin
2,295828
asked 6 hours ago
Orin Huff
1
New contributor
Orin Huff is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 5 hours ago
Albin
2,295828
edited 5 hours ago
Albin
2,295828
edited 5 hours ago
Albin
2,295828
2,295828
asked 6 hours ago
Orin Huff
1
New contributor
Orin Huff is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 6 hours ago
Orin Huff
1
asked 6 hours ago
Orin Huff
1
1
New contributor
Orin Huff is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Orin Huff is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Orin Huff 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
up vote
0
down vote
=INDEX(D4:R33,MATCH(V3,C4:C33,0),MATCH(W3,D3:R3,0))
Do match for both axis in the index.. That's I think the part that do the job. ( :
Hope it helps..
answered 5 hours ago
p._phidot_
47328
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
=INDEX(D4:R33,MATCH(V3,C4:C33,0),MATCH(W3,D3:R3,0))
Do match for both axis in the index.. That's I think the part that do the job. ( :
Hope it helps..
answered 5 hours ago
p._phidot_
47328
add a comment |
up vote
0
down vote
=INDEX(D4:R33,MATCH(V3,C4:C33,0),MATCH(W3,D3:R3,0))
Do match for both axis in the index.. That's I think the part that do the job. ( :
Hope it helps..
answered 5 hours ago
p._phidot_
47328
add a comment |
up vote
0
down vote
up vote
0
down vote
=INDEX(D4:R33,MATCH(V3,C4:C33,0),MATCH(W3,D3:R3,0))
Do match for both axis in the index.. That's I think the part that do the job. ( :
Hope it helps..
answered 5 hours ago
p._phidot_
47328
=INDEX(D4:R33,MATCH(V3,C4:C33,0),MATCH(W3,D3:R3,0))
Do match for both axis in the index.. That's I think the part that do the job. ( :
Hope it helps..
answered 5 hours ago
p._phidot_
47328
answered 5 hours ago
p._phidot_
47328
answered 5 hours ago
p._phidot_
47328
answered 5 hours ago
p._phidot_
47328
47328
add a comment |
add a comment |
Orin Huff is a new contributor. Be nice, and check out our Code of Conduct.
Orin Huff is a new contributor. Be nice, and check out our Code of Conduct.
Orin Huff is a new contributor. Be nice, and check out our Code of Conduct.
Orin Huff 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%2f1376044%2freturning-row-and-column-value-in-a-large-chart-if-column-is-in-a-range%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
