Formula for .. IF Partial Match = PASTE, IF NO MATCH = BLANK

Hello everyone,   I'm looking for a partial match formula.   I'm looking to partial match cell $D5 in my excel spreadsheet with $K$28:$K$400.   $D5 must be a PARTIAL MATCH to ANY of the cells i...