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