Excel: lookup multiple lines with a wildcard This is a workaround I found: The formula in the D3 cell is =FILTER(A:B,ISNUMBER(FIND(D3,A:A)))