Hello, everyone.
I am hoping someone could help me with an index/match function to generate a report based on multiple criteria. I actually want to be able to copy a whole column of data based on 3 criteria that the user will fill.
Fig. 1 contains my database and Fig. 2 is the report I want to generate based on the week #, date and legend. I need the whole column copied to the "Reports" sheet depending on the 3 criteria.
Appreciate your kind assistance.
I am hoping someone could help me with an index/match function to generate a report based on multiple criteria. I actually want to be able to copy a whole column of data based on 3 criteria that the user will fill.
Fig. 1 contains my database and Fig. 2 is the report I want to generate based on the week #, date and legend. I need the whole column copied to the "Reports" sheet depending on the 3 criteria.
Appreciate your kind assistance.