I am trying to create a formula that is based on two different cells within the same tab (Comments) in my workbook. I have attached the workbook as a reference.
For example, on the main tab (Report), when I select LOCATION, I am able to choose between various locations. Once a location is selected, I can then select DATE, which is the date I visited that location.
After selecting both, I want it to display that information originating from the COMMENTS tab on the REPORT tab. The desired information will be displayed in the highlighted yellow areas
On the comments tab, it lists multiple entries (comments) from multiple locations and dates. Is there a formula that can narrow down to a specific location then desired date based on the before mentioned data-validation selection, and lists each “task performed”/”comments” for that selection?
All help and assistance is much appreciated!