Find a value in a table using column header and row values?
up vote
0
down vote
favorite
I'm organizing my tax savings by pay period so I know what is available as an owner draw or investment....
Given I have a pay date as a column header in another table, and I have a data table containing Tax savings by tax type, how do I pull the tax savings value for a specific pay date?
I need to find the highlighted values based on the two existing tables.
Tax Savings Tables
microsoft-excel worksheet-function
asked 2 days ago
user3889297
1
New contributor
user3889297 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
I'm organizing my tax savings by pay period so I know what is available as an owner draw or investment....
Given I have a pay date as a column header in another table, and I have a data table containing Tax savings by tax type, how do I pull the tax savings value for a specific pay date?
I need to find the highlighted values based on the two existing tables.
Tax Savings Tables
microsoft-excel worksheet-function
asked 2 days ago
user3889297
1
New contributor
user3889297 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
Use MATCH() to find the number of each value (header name, row value) in their reference arrays. Obtain the reference to the cell you need using INDEX() function.
– Akina
2 days ago
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I'm organizing my tax savings by pay period so I know what is available as an owner draw or investment....
Given I have a pay date as a column header in another table, and I have a data table containing Tax savings by tax type, how do I pull the tax savings value for a specific pay date?
I need to find the highlighted values based on the two existing tables.
Tax Savings Tables
microsoft-excel worksheet-function
asked 2 days ago
user3889297
1
New contributor
user3889297 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I'm organizing my tax savings by pay period so I know what is available as an owner draw or investment....
Given I have a pay date as a column header in another table, and I have a data table containing Tax savings by tax type, how do I pull the tax savings value for a specific pay date?
I need to find the highlighted values based on the two existing tables.
Tax Savings Tables
microsoft-excel worksheet-function
microsoft-excel worksheet-function
asked 2 days ago
user3889297
1
New contributor
user3889297 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 days ago
user3889297
1
New contributor
user3889297 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 days ago
user3889297
1
New contributor
user3889297 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 days ago
user3889297
1
asked 2 days ago
user3889297
1
1
New contributor
user3889297 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
user3889297 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
user3889297 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
Use MATCH() to find the number of each value (header name, row value) in their reference arrays. Obtain the reference to the cell you need using INDEX() function.
– Akina
2 days ago
add a comment |
1
Use MATCH() to find the number of each value (header name, row value) in their reference arrays. Obtain the reference to the cell you need using INDEX() function.
– Akina
2 days ago
1
1
Use MATCH() to find the number of each value (header name, row value) in their reference arrays. Obtain the reference to the cell you need using INDEX() function.
– Akina
2 days ago
Use MATCH() to find the number of each value (header name, row value) in their reference arrays. Obtain the reference to the cell you need using INDEX() function.
– Akina
2 days ago
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
user3889297 is a new contributor. Be nice, and check out our Code of Conduct.
user3889297 is a new contributor. Be nice, and check out our Code of Conduct.
user3889297 is a new contributor. Be nice, and check out our Code of Conduct.
user3889297 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%2f1376040%2ffind-a-value-in-a-table-using-column-header-and-row-values%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
1
Use MATCH() to find the number of each value (header name, row value) in their reference arrays. Obtain the reference to the cell you need using INDEX() function.
– Akina
2 days ago