Category "multiple-value"

Excel - multiple value search across multiple columns or one column with multiple values

I have 7 criteria = TMO-1 through to TMO-7 I have two scenarios to search from. i have either got a single excel with TMO-6, TMO-201, TMO-67,... etc (some have