Formula Based on Multi-Level Data Validation Selection

Greetings,

I created 2 different tabs (‘Klause 19-9’ & ‘Hendrick 27-7’) with the same type of information (Date, Chemical Name, Type, etc.) on each tab. For further reference, see the attachment for example.

Additionally, I created dependent data validation lists.

Location:
Klause_19_9
Hendrick_27_7

Date:
Will bring up certain date(s), depending which location is chosen

When you click under “select area” you are given either a choice for location. When you choose either, under “select date” you can that location’s listed dates, based on your previous selection.

My question is:

How do I create formulas that list the respective information (Date, Chemical Name, Type,) from the selected tab based on the desired date/location? Also, if there is multiple data entries for a single date, will they both be listed?

Thanks much for all contribution and assistance!

Example5.xlsx

Vlady,

Thanks for the response. It worked smoothly with Klause 19-9. However, when I clicked on Hendrick 27-7, I tried to change the date (from 1/15 to 1/14) and was not able. Therefore, I was not able to adjust to Hendrick's data. How can i change this? Thanks again for your assistance!

bebo021999,

Fantastic! Works like a charm!

I greatly appreciate your assistance!

bebo021999,

After your speedy assistance this afternoon, I began to "clean up" my document by editing the visual format (color, layout, etc). However, something I did messed up some of the columns in the table you created.

Additionally, I added another data point (previous service date). I have tried to figure out your formula by copying its format so I can add the data to the table, but have been unsuccessful. Would you mind taking another look at and let me know where to go from here?

Again, I'm very grateful for your assistance!

RoughDraft.xlsx