Excel look up date by value in another column [closed]
up vote
-1
down vote
favorite
I want to look up the all the data on the right circle 1 by 1 in column1 and input the date in the middle circle simultaneously. Is it possible in Excel?
microsoft-excel
edited Dec 5 at 8:47
Mokubai♦
56.3k16133152
asked Dec 5 at 8:40
user970090
1
closed as unclear what you're asking by Máté Juhász, fixer1234, bertieb, Rajesh S, n8te Dec 11 at 7:49
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
up vote
-1
down vote
favorite
I want to look up the all the data on the right circle 1 by 1 in column1 and input the date in the middle circle simultaneously. Is it possible in Excel?
microsoft-excel
edited Dec 5 at 8:47
Mokubai♦
56.3k16133152
asked Dec 5 at 8:40
user970090
1
closed as unclear what you're asking by Máté Juhász, fixer1234, bertieb, Rajesh S, n8te Dec 11 at 7:49
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
Simply useINDEX&MATCHcombination. ☺
– Rajesh S
Dec 5 at 8:53
3
what date do you want to enter there? Is it possible to post also editable data too, so we could work on it? (you can format your data e.g. here: tablesgenerator.com/markdown_tables)
– Máté Juhász
Dec 5 at 8:59
1
It isn't clear what you're asking. What are you looking up against what?
– fixer1234
Dec 6 at 0:30
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
I want to look up the all the data on the right circle 1 by 1 in column1 and input the date in the middle circle simultaneously. Is it possible in Excel?
microsoft-excel
edited Dec 5 at 8:47
Mokubai♦
56.3k16133152
asked Dec 5 at 8:40
user970090
1
I want to look up the all the data on the right circle 1 by 1 in column1 and input the date in the middle circle simultaneously. Is it possible in Excel?
microsoft-excel
microsoft-excel
edited Dec 5 at 8:47
Mokubai♦
56.3k16133152
asked Dec 5 at 8:40
user970090
1
edited Dec 5 at 8:47
Mokubai♦
56.3k16133152
asked Dec 5 at 8:40
user970090
1
edited Dec 5 at 8:47
Mokubai♦
56.3k16133152
edited Dec 5 at 8:47
Mokubai♦
56.3k16133152
edited Dec 5 at 8:47
Mokubai♦
56.3k16133152
56.3k16133152
asked Dec 5 at 8:40
user970090
1
asked Dec 5 at 8:40
user970090
1
asked Dec 5 at 8:40
user970090
1
1
closed as unclear what you're asking by Máté Juhász, fixer1234, bertieb, Rajesh S, n8te Dec 11 at 7:49
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
closed as unclear what you're asking by Máté Juhász, fixer1234, bertieb, Rajesh S, n8te Dec 11 at 7:49
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
Simply useINDEX&MATCHcombination. ☺
– Rajesh S
Dec 5 at 8:53
3
what date do you want to enter there? Is it possible to post also editable data too, so we could work on it? (you can format your data e.g. here: tablesgenerator.com/markdown_tables)
– Máté Juhász
Dec 5 at 8:59
1
It isn't clear what you're asking. What are you looking up against what?
– fixer1234
Dec 6 at 0:30
add a comment |
Simply useINDEX&MATCHcombination. ☺
– Rajesh S
Dec 5 at 8:53
3
what date do you want to enter there? Is it possible to post also editable data too, so we could work on it? (you can format your data e.g. here: tablesgenerator.com/markdown_tables)
– Máté Juhász
Dec 5 at 8:59
1
It isn't clear what you're asking. What are you looking up against what?
– fixer1234
Dec 6 at 0:30
Simply use
INDEX & MATCH combination. ☺– Rajesh S
Dec 5 at 8:53
Simply use
INDEX & MATCH combination. ☺– Rajesh S
Dec 5 at 8:53
3
3
what date do you want to enter there? Is it possible to post also editable data too, so we could work on it? (you can format your data e.g. here: tablesgenerator.com/markdown_tables)
– Máté Juhász
Dec 5 at 8:59
what date do you want to enter there? Is it possible to post also editable data too, so we could work on it? (you can format your data e.g. here: tablesgenerator.com/markdown_tables)
– Máté Juhász
Dec 5 at 8:59
1
1
It isn't clear what you're asking. What are you looking up against what?
– fixer1234
Dec 6 at 0:30
It isn't clear what you're asking. What are you looking up against what?
– fixer1234
Dec 6 at 0:30
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
in H2.. put =index(B:B,match(L2,A:A,0)) then drag it until the last column H element.
You may learn the trick by doing a search of "index match in excel" keyword or excel help file. In this case, the match() part look for a match of the L2 data in A:A, then using it's location(row) in A:A was returned to index(), where it call the value from B:B at the same location (row).
answered Dec 6 at 6:07
p._phidot_
49028
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
in H2.. put =index(B:B,match(L2,A:A,0)) then drag it until the last column H element.
You may learn the trick by doing a search of "index match in excel" keyword or excel help file. In this case, the match() part look for a match of the L2 data in A:A, then using it's location(row) in A:A was returned to index(), where it call the value from B:B at the same location (row).
answered Dec 6 at 6:07
p._phidot_
49028
add a comment |
up vote
0
down vote
in H2.. put =index(B:B,match(L2,A:A,0)) then drag it until the last column H element.
You may learn the trick by doing a search of "index match in excel" keyword or excel help file. In this case, the match() part look for a match of the L2 data in A:A, then using it's location(row) in A:A was returned to index(), where it call the value from B:B at the same location (row).
answered Dec 6 at 6:07
p._phidot_
49028
add a comment |
up vote
0
down vote
up vote
0
down vote
in H2.. put =index(B:B,match(L2,A:A,0)) then drag it until the last column H element.
You may learn the trick by doing a search of "index match in excel" keyword or excel help file. In this case, the match() part look for a match of the L2 data in A:A, then using it's location(row) in A:A was returned to index(), where it call the value from B:B at the same location (row).
answered Dec 6 at 6:07
p._phidot_
49028
in H2.. put =index(B:B,match(L2,A:A,0)) then drag it until the last column H element.
You may learn the trick by doing a search of "index match in excel" keyword or excel help file. In this case, the match() part look for a match of the L2 data in A:A, then using it's location(row) in A:A was returned to index(), where it call the value from B:B at the same location (row).
answered Dec 6 at 6:07
p._phidot_
49028
answered Dec 6 at 6:07
p._phidot_
49028
answered Dec 6 at 6:07
p._phidot_
49028
answered Dec 6 at 6:07
p._phidot_
49028
49028
add a comment |
add a comment |
Simply use
INDEX&MATCHcombination. ☺– Rajesh S
Dec 5 at 8:53
3
what date do you want to enter there? Is it possible to post also editable data too, so we could work on it? (you can format your data e.g. here: tablesgenerator.com/markdown_tables)
– Máté Juhász
Dec 5 at 8:59
1
It isn't clear what you're asking. What are you looking up against what?
– fixer1234
Dec 6 at 0:30