I have Sheet 1 with an account number in column a and column B-Y are different products that each account may own. I would like to have the sheet filled out as seen below. I think I will be able to fill in the X's using Index Match.
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Account#[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[TD]O[/TD]
[TD]P[/TD]
[TD]Q[/TD]
[TD]R[/TD]
[TD]S[/TD]
[TD]T[/TD]
[TD]U[/TD]
[TD]V[/TD]
[TD]W[/TD]
[TD]X[/TD]
[TD]Y[/TD]
[TD]Z[/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]14331937[/TD]
</tbody>[/TD]
[TD][/TD]
[TD="align: center"]x[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]x[/TD]
[/TR]
[TR]
[TD][TABLE="width: 84"]
<tbody>[TR="class: grid"]
[TD="width: 84, align: right"]14346609[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]x[/TD]
[TD][/TD]
[TD="align: center"]x[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I have a second sheet in which each row contains an account number in Column A and a product they own in Column B. Each account number may own multiple products which will be found on multiple rows.
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD]Account#[/TD]
[TD]Product[/TD]
[/TR]
[TR]
[TD]14331937[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]14331937[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD]14331937[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]14331937[/TD]
[TD]Z[/TD]
[/TR]
[TR]
[TD][TABLE="width: 84"]
<tbody>[TR="class: grid"]
[TD="width: 84"]14346609[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD][TABLE="width: 84"]
<tbody>[TR="class: grid"]
[TD="width: 84"]14346609[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD][TABLE="width: 84"]
<tbody>[TR="class: grid"]
[TD="width: 84"]14346609[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD][TABLE="width: 84"]
<tbody>[TR="class: grid"]
[TD="width: 84"]14346609[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD][TABLE="width: 84"]
<tbody>[TR="class: grid"]
[TD="width: 84"]14346609[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]T[/TD]
[/TR]
[TR]
[TD]14346609[/TD]
[TD]W[/TD]
[/TR]
</tbody>[/TABLE]
I have never used Index Match.
Thanks in Advance for your help.
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Account#[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[TD]O[/TD]
[TD]P[/TD]
[TD]Q[/TD]
[TD]R[/TD]
[TD]S[/TD]
[TD]T[/TD]
[TD]U[/TD]
[TD]V[/TD]
[TD]W[/TD]
[TD]X[/TD]
[TD]Y[/TD]
[TD]Z[/TD]
[/TR]
[TR]
[TD]
<tbody>
[TD="align: right"]14331937[/TD]
</tbody>
[TD][/TD]
[TD="align: center"]x[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]x[/TD]
[/TR]
[TR]
[TD][TABLE="width: 84"]
<tbody>[TR="class: grid"]
[TD="width: 84, align: right"]14346609[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]x[/TD]
[TD][/TD]
[TD="align: center"]x[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I have a second sheet in which each row contains an account number in Column A and a product they own in Column B. Each account number may own multiple products which will be found on multiple rows.
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD]Account#[/TD]
[TD]Product[/TD]
[/TR]
[TR]
[TD]14331937[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]14331937[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD]14331937[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]14331937[/TD]
[TD]Z[/TD]
[/TR]
[TR]
[TD][TABLE="width: 84"]
<tbody>[TR="class: grid"]
[TD="width: 84"]14346609[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD][TABLE="width: 84"]
<tbody>[TR="class: grid"]
[TD="width: 84"]14346609[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD][TABLE="width: 84"]
<tbody>[TR="class: grid"]
[TD="width: 84"]14346609[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD][TABLE="width: 84"]
<tbody>[TR="class: grid"]
[TD="width: 84"]14346609[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD][TABLE="width: 84"]
<tbody>[TR="class: grid"]
[TD="width: 84"]14346609[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]T[/TD]
[/TR]
[TR]
[TD]14346609[/TD]
[TD]W[/TD]
[/TR]
</tbody>[/TABLE]
I have never used Index Match.
Thanks in Advance for your help.