Forum Discussion
Excel Question: Daily Update data next to a date cell
I've attached a spreadsheet that shows two ways to accomplish this. (One delightful feature of Excel is that there are often multiple ways "to skin a cat."
=VLOOKUP(A2,A12:B41,2,0) does it by looking up the value next to the date in the table of data.
=FILTER(B12:B41,A12:A41=A2,"empty") uses a newer function (FILTER) which is only available if you have the newest version of Excel. This function can be more powerful if you have several values with the same date, and want them all to show. Or by refining and adding more criteria, you can focus on specifics more easily.
I've attached a spreadsheet that shows two ways to accomplish this. (One delightful feature of Excel is that there are often multiple ways "to skin a cat."
=VLOOKUP(A2,A12:B41,2,0) does it by looking up the value next to the date in the table of data.
=FILTER(B12:B41,A12:A41=A2,"empty") uses a newer function (FILTER) which is only available if you have the newest version of Excel. This function can be more powerful if you have several values with the same date, and want them all to show. Or by refining and adding more criteria, you can focus on specifics more easily.
- thank you so much! that's exactly what I needed.
