Assets Consolidation - Searching and Comparing fields with multiple IP Addresses

[munisb]

Hi,

I have this query where I am trying to compare two csv files and have the assets data merged

CSV1

host	ip	os
abc.domain.com	1.1.1.1	Windows
def	2.2.2.3	suse
xyz	3.3.3.3	aix

CSV2

Name	IP Addresses	Description	OS
abc	1.1.1.1	blah blah	windows
abc.domain.com	1.1.1.1, 2.2.2.1	blah blah	windows
bcd	1.1.1.2, 2.2.2.2	blah blah	windows
def.domain.com	1.1.1.3, 2.2.2.3	blah blah	suse
xyz		blah blah	aix

| inputlookup CSV1.csv | lookup CSV2.csv "IP Addresses" as ip | table Name, host, ip, OS, os | fillnull Name value="Not Found"

With this query - for some reason i am not able to correlate assets that have multiple "IP Addresses" in CSV2. How can I ensure that any value in the cell is searched instead of having an exact match?

Thank you