Column match on same row

[kway2004]

I have a table with Sku and Item Name. There are multiple lines with the same Sku. I want to take this information and create a table showing one line for the sku name and place an "X" with the Item Name that make up the Sku.

Beginning data table

SKU	Item Name
ELF02	Beef Bully Stick 6"
ELF02	Small Generic Box
ELF02	Box Label Small
ELF02	Beef Label
ELF03	Beef Bully Stick 12"
ELF03	Small Generic Box
ELF03	Box Label Small
ELF03	Beef Label

<colgroup><col><col></colgroup><tbody>
</tbody>

End result that I am seeking

	Beef Bully Stick 6"	Beef Bully Stick 12"	Small Generic Box	Box Label Small	Beef Label
ELF02	X		X	X	X
ELF03		X	X	X	X

<colgroup><col span="6"></colgroup><tbody>
</tbody>

Of course the beginning table has about 1200 lines to it. I have tried If(And(match which gives me "X" in cell that should not have them because of the condition is satisfied once it finds a match in both columns. I need the column match to be for the same row.

 

[Fluff]

How about

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style=";">SKU</td><td style=";">Item Name</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Beef Bully Stick 6"</td><td style=";">Beef Bully Stick 12"</td><td style=";">Small Generic Box</td><td style=";">Box Label Small</td><td style=";">Beef Label</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style=";">ELF02</td><td style=";">Beef Bully Stick 6"</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style=";">ELF02</td><td style=";">Small Generic Box</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">ELF02</td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;">X</td><td style="text-align: center;;">X</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style=";">ELF02</td><td style=";">Box Label Small</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">ELF03</td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;">X</td><td style="text-align: center;;">X</td><td style="text-align: center;;">X</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style=";">ELF02</td><td style=";">Beef Label</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style=";">ELF03</td><td style=";">Beef Bully Stick 12"</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style=";">ELF03</td><td style=";">Small Generic Box</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style=";">ELF03</td><td style=";">Box Label Small</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style=";">ELF03</td><td style=";">Beef Label</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:5.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Summary</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">G3</th><td style="text-align:left">=IF(<font color="Blue">ISNUMBER(<font color="Red">MATCH(<font color="Green">$F3&"|"&G$1,INDEX(<font color="Purple">$A$2:$A$9&"|"&$B$2:$B$9,0</font>),0</font>)</font>),"X",""</font>)</td></tr></tbody></table></td></tr></table><br />

 

[kway2004]

Your formula works perfectly. Thank you

 

[Fluff]

You're welcome & thanks for the feedback