Lookup multiple partial match conditions and return values

Hi darklan, and welcome.

Haseeb's solution is elegant - I'll be using that one again in the future!

I notice that you have a duplicate in T-200/DC01, so I've also set it up to list duplicate entries (using helper columns, as I find it easier to see what's going on).

I echo Haseeb's request that you post .xls files in the future...