SumProduct Question

[G12Consult]

I have the following sum product formula which works perfectly however I want it to return Yes if true, blank for false.

At the moment its returning 1 for true and 0 for false

=INDEX(SUMPRODUCT(--(HolidayLookup[HOLIDAY_DATE]=E85),--(HolidayLookup[HLDY_GROUP_CODE]=J85),--(HolidayLookup[HOLIDAY_YEAR]=K85)),0)

 

[SkipVought]

[TT]
=if(SUMPRODUCT(
--(HolidayLookup[HOLIDAY_DATE]=E85),
--(HolidayLookup[HLDY_GROUP_CODE]=J85),
--(HolidayLookup[HOLIDAY_YEAR]=K85))=1,"YES","")
[/TT]

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]