I am working on a project for work that involves over a thousand part numbers. Please refer to the tables below as examples:
Table 1: Main
<tbody>
</tbody>
Table 2: Materials
<tbody>
</tbody>
I need to take Table 1:Main and place an X every time a part number is used in Table 2: Materials. I need it to look like this:
<tbody>
</tbody>
Both Table 1: Main and Table 2: Materials are in different sheets because Table 1: Main has 466 rows while Table 2: Materials has 1212 rows. I have tried if statements, nested if statements within a vlookup, vlookup with match, etc. I tried =IF(AND($C4='Packaging Material'!$B$2:$B$1212, N$3='Packaging Material'!$F$2:$F$1212),"X", "") and it will only show a X on some of the packaging items (i.e. plastic, paper, sticker, cloth, string) but not on all of them.
Will someone please help me? I really do not want to manually put in the X's for that many rows of data.
Table 1: Main
Part # | Part Descrp. | plastic | paper | sticker | cloth | string |
123 | balloon | |||||
124 | brush | |||||
125 | CD | |||||
126 | Pillow |
<tbody>
</tbody>
Table 2: Materials
Part # | Part Descrp. | Pkg Items |
123 | balloon | plastic |
123 | balloon | string |
124 | brush | plastic |
124 | brush | paper |
125 | CD | plastic |
125 | CD | sticker |
125 | CD | paper |
126 | Pillow | cloth |
126 | Pillow | sticker |
<tbody>
</tbody>
I need to take Table 1:Main and place an X every time a part number is used in Table 2: Materials. I need it to look like this:
Part # | Part Descrp. | plastic | paper | sticker | cloth | string |
123 | balloon | X | X | |||
124 | brush | X | X | |||
125 | CD | X | X | X | ||
126 | Pillow | X | X |
<tbody>
</tbody>
Both Table 1: Main and Table 2: Materials are in different sheets because Table 1: Main has 466 rows while Table 2: Materials has 1212 rows. I have tried if statements, nested if statements within a vlookup, vlookup with match, etc. I tried =IF(AND($C4='Packaging Material'!$B$2:$B$1212, N$3='Packaging Material'!$F$2:$F$1212),"X", "") and it will only show a X on some of the packaging items (i.e. plastic, paper, sticker, cloth, string) but not on all of them.
Will someone please help me? I really do not want to manually put in the X's for that many rows of data.