Forum Discussion
Solved
Look for actual value
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 ...
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:
Greg_Deckler You helped me a lot. This is exactly what I was looking for.