I've discovered a new, useful Excel formula. The TEXTJOIN formula is an alternative to Vlookup that we might utilize.

This formula looks up the values and brings up all the criteria that match, however vlookup did not expect all the matching data, but this formula did. because using vlookup to look up a value in a specific table only returns the first item, whereas TEXTJOIN can return all matches. Please see the sample below.

SYNTAX
TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)

DAYS (A) HOLIDAY (B)
SUN Y
MON
TUE Y
WED Y
THU
FRI

SAT

applied formula

=TEXTJOIN(",",TRUE,IF(B2:B8="Y",A2:A8,""))

result: SUN,TUE,WED

I have included a basic example above, but you can also use sub-formulas like sumif and countif inside the textjoin formula.

see you soon with new one.

Thanks
Balakathiresan(கதிர்)