Filter/Xlookup error

[Jedi Master]

Hello Everyone! Would someone be able to help me with understanding and fixing the error I am getting when trying to filter results? It is finding the correct results(Name values based on date entered and hours >0), but returning a portion of them as errors. When I go through the calculation steps it shows that it finds the correct values but returns some portion of the list as #N/A:

Below is the referenced PM Project tracker in the above formula bar:

 

[Fluff]

Get rid of the 2nd IF & just use the filter.

 

[Jedi Master]

Get rid of the 2nd IF & just use the filter.

Thank you so much!!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Jedi Master]

You're welcome & thanks for the feedback.

Using the same data sets and screenshots is there a way to filter the numerical values to just the numbers above zero for the corresponding date for the "HRS" column in the 2nd screenshot? Would this be an index/match function?

 

[Fluff]

If you are on about col E, then there are no dates for that column.

 

[Jedi Master]

If you are on about col E, then there are no dates for that column.

It would be pulling the corresponding values of hours from the array for the given date matched to the name. Should look like the below:

 

[Fluff]

You can use LET to store the result of the xlookup in a variable & then use vstack to add that to the range being filtered.

 

[Jedi Master]

You can use LET to store the result of the xlookup in a variable & then use vstack to add that to the range being filtered.

While I could not get that to work as I am unfamiliar with those functions, I did get the following to work, thank you very much for your help!:

=IF(ISBLANK($G11),"",IF(SUMPRODUCT(('PM Project Tracker'!M9:UM21)*('PM Project Tracker'!C9:C21=G15)*('PM Project Tracker'!M4:UM4=G11))=0,"",SUMPRODUCT(('PM Project Tracker'!M9:UM21)*('PM Project Tracker'!C9:C21=G15)*('PM Project Tracker'!M4:UM4=$G11))))

 

[Fluff]

Can you post your original formula?