Looking in multiple reference tables

Hello

I'm trying to setup a system of 2 groups of tables, one referencing the another. Attaching an example.
On the left i have tables of Apples, at what time which apples are going to be in which baskets.
On the right are just the Baskets tables that output which apples are at what basket are at the specified times.
In the Baskets "c" table i already have a formula to look for "c" in the Apples table and output one cell left - the apples.

How can i make it search all the Apples tables at one specific time for the baskets (a, b, c, d) and output the value (apples) left from the found correct value?
And if possible to warm me if 2 sets of apples are in the same basket at the same time?

Peaches.JPG

Thank you!