[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 146"]
<tbody>[TR]
[TD="width: 146"]US20060071206[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 425"]
<tbody>[TR]
[TD="width: 425"]US20060071206, CN100549016C, CN1711275A, DE10251986, DE200210251986, EP1562964, JP2006505600, JP4494211, US7414133, WO2004041835[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]If Value in C1R1 is present in C2R1, then value=C1R1[/TD]
[/TR]
[TR]
[TD][TABLE="width: 146"]
<tbody>[TR]
[TD]US20060172146[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 425"]
<tbody>[TR]
[TD="width: 425"]US20060172146, AT526381, CN100523121C, CN1774490A, EP1620525B, JP2003132257, JP200488575, JP2006526278, JP4642016, KR956051, US2005548669, US20100019670, US7615633, US8257838, WO2004099339[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]US20060182992[/TD]
[TD][TABLE="width: 425"]
<tbody>[TR]
[TD="width: 425"]US20060182992, 2009395358, CN100551994C, CN101667626A, CN1777663A, CN200480010948, EP1629063A, JP2003157006, JP2004162849, JP200492274, JP2005310733, JP2010062577, JP2010080982, JP2010118670, JP4460952, JP5081221, KR1098807, KR20060016087, US2005551653, US2009174324, US7569692, US8211553, WO2004108857[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Hello Folks,
I am stuck with a index/match shenanigan. I have to find out if valle in C1R1 is present in a comma separated values in C2R1 and if it does, C3R1 should be same as C1R1. All I am getting is #N/A. How to I tackle this problem? I can not use vlookup because it does not work for cell that has more than 255 characters.
<tbody>[TR]
[TD][TABLE="width: 146"]
<tbody>[TR]
[TD="width: 146"]US20060071206[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 425"]
<tbody>[TR]
[TD="width: 425"]US20060071206, CN100549016C, CN1711275A, DE10251986, DE200210251986, EP1562964, JP2006505600, JP4494211, US7414133, WO2004041835[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]If Value in C1R1 is present in C2R1, then value=C1R1[/TD]
[/TR]
[TR]
[TD][TABLE="width: 146"]
<tbody>[TR]
[TD]US20060172146[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 425"]
<tbody>[TR]
[TD="width: 425"]US20060172146, AT526381, CN100523121C, CN1774490A, EP1620525B, JP2003132257, JP200488575, JP2006526278, JP4642016, KR956051, US2005548669, US20100019670, US7615633, US8257838, WO2004099339[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]US20060182992[/TD]
[TD][TABLE="width: 425"]
<tbody>[TR]
[TD="width: 425"]US20060182992, 2009395358, CN100551994C, CN101667626A, CN1777663A, CN200480010948, EP1629063A, JP2003157006, JP2004162849, JP200492274, JP2005310733, JP2010062577, JP2010080982, JP2010118670, JP4460952, JP5081221, KR1098807, KR20060016087, US2005551653, US2009174324, US7569692, US8211553, WO2004108857[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Hello Folks,
I am stuck with a index/match shenanigan. I have to find out if valle in C1R1 is present in a comma separated values in C2R1 and if it does, C3R1 should be same as C1R1. All I am getting is #N/A. How to I tackle this problem? I can not use vlookup because it does not work for cell that has more than 255 characters.