Question Details

No question body available.

Tags

google-sheets google-sheets-formula

Answers (1)

January 21, 2026 Score: 1 Rep: 22,190 Quality: Low Completeness: 70%

Use ifna(), join() and filter(), like this:

=ifna(unique(join(", ", filter(
  'Sales DB'!C$2:C, 
  'Sales DB'!C$2:C  B2, 
  'Sales DB'!D$2:D = C2,
  'Sales DB'!A$2:A = left(D2, len('Sales DB'!A$2:A))
))))

screenshot]

The unique() is only necessary if you want to remove possible duplicates.

See ifna(), unique(), join() and filter().