Look for actual value

[jhonatansdias]

Hello everybody,
I'm trying to do a search in a table and populate another table.

In the example below I have a table called t1 that has the column Current and Quantity.
What I want is to fill in table 2. That is, look for This month of t2 in t1 and bring the quantity.
If in the table t2 in the Current column there is a repeated value, I have to bring the most current value

[jhonatansdias]

@Greg_Deckler You helped me a lot. This is exactly what I was looking for.

[Greg_Deckler · Accepted solution]

@jhonatansdias This is a double lookup. Use MAXX(FILTER(...),...) twice essentially. Basically, look up the MAXX date filtering by your month name. Once you have that, do another MAXX(FILTER to filter down to just that date and return that quantity. See if this helps: