Search comma separated cell from data in column

[Ucubia]

Hi,

I have a list of data in Column A of a sheet, it is an asset identifier. so would look like

A120001
A120029
A127931
etc...etc

Another sheet which has many rows identifying location in Column A and Column B the asset identifiers that are separated with comma, for example

row 2 Location-1 A120001, A127931, A128335
row 3 Location-2 A12001,A12700
row 4 Location-3 A120001, A120029, A137617

I am trying to pull together a way to identify any items in the Location sheet that are not in the sheet containing just the asset identifiers - for example, Location-1 should report just A128335

Any advice as to how to make this happen without VBA would be good.

Many thank