Aug 29 2022 09:09 AM - edited Aug 29 2022 09:26 AM
I need help setting up a formula that will be able to pull in the correct column of data from a separate tab when the date is changed. I am unsure which formula to use to get my desired result. I have tried using index match but I could not figure a way to make it work.
If anyone knows how I can attach the file to this please let me know.
Aug 29 2022 09:20 AM
These are clearly made up figures. But in the first photo, I would like to be able to set up a formula in the column for July 31, 2021 that will pull in from another sheet in the same workbook (see photo 2)
When the date is changed each month, the formula would automatically update and pull in whatever month is needed.
PHOTO 1
PHOTO 2
Aug 29 2022 09:39 AM
Aug 29 2022 12:07 PM
Solution@em_st3r got it and here is the example using Filter(). i also used data validation to create a drop down for the date selection.
Aug 29 2022 12:07 PM
Solution@em_st3r got it and here is the example using Filter(). i also used data validation to create a drop down for the date selection.