Comparing Columns

Hello,

I am trying to compare column A (location) against column I (location),with desired result in column J from Column B, if not found then show -

Same for comparing compare column A (location) against column I (location),with desired result in column K from Column D. if not found then show -

If any of the words match in column A that are in column I, then show the desired result.

See attachment.


Thanks

You have some trailing spaces in A, but this should cover it..
=INDEX(B:B,MATCH("*"&LEFT(I2,FIND(",",I2)-1)&"*",A:A,0))
copied down

See if you can adapt that for K?