Matching a vertical data set with a horizontal set

[gutie049]

Hello,

I need to fill in a table by matching the vertical number in Column J with the horizontal number in Row 3 and then entering a 1 if they match or blank if they do not match. I've added a 1 at the intersection of N4 because both the vertical and horizontal numbers are 31494. Table looks like this:
DFW

	I	J	K	L	M	N	O	P	Q

<tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]

[TD="colspan: 14, align: center"]YEAR ROUND[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=daecf4]#daecf4[/URL] , align: center"]Item Names[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=daecf4]#daecf4[/URL] , align: center"]ITEM[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=daecf4]#daecf4[/URL] , align: center"]90 Days[/TD]
[TD="align: center"]DF 60 MINUTE IPA 12/19.2 CAN[/TD]
[TD="align: center"]DF 60 MINUTE IPA 2/12/12 CAN[/TD]
[TD="align: center"]DF 60 MINUTE IPA 4/6/12NR[/TD]
[TD="align: center"]DF 90 MINUTE IPA HD 6/4/12NR[/TD]
[TD="align: center"]DF BURTON 6/4/12NR[/TD]
[TD="align: center"]DF FLESH AND BLOOD 4/6/12 CAN[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]
[TD="align: left"]Total[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=f1f0f0]#f1f0f0[/URL] , align: center"]40587[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=f1f0f0]#f1f0f0[/URL] , align: center"]39941[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=f1f0f0]#f1f0f0[/URL] , align: center"]31494[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=f1f0f0]#f1f0f0[/URL] , align: center"]31502[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=f1f0f0]#f1f0f0[/URL] , align: center"]31506[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=f1f0f0]#f1f0f0[/URL] , align: center"]40022[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]
[TD="align: left"]DF 60 MINUTE IPA 4/6/12NR[/TD]
[TD="align: left"]31494[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]5[/TD]
[TD="align: left"]DF 60 MINUTE IPA 2/12/12 CAN[/TD]
[TD="align: left"]39941[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]6[/TD]
[TD="align: left"]DF SEAQUENCH ALE 4/6/12 CAN[/TD]
[TD="align: left"]40023[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]7[/TD]
[TD="align: left"]DF 90 MINUTE IPA HD 6/4/12NR[/TD]
[TD="align: left"]31502[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]8[/TD]
[TD="align: left"]DF INDIAN BROWN 4/6/12NR[/TD]
[TD="align: left"]31496[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]9[/TD]
[TD="align: left"]DF ROMANTIC CHEMISTRY 4/6/12 NR[/TD]
[TD="align: left"]40718[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]10[/TD]
[TD="align: left"]DF FESTINA PECHE 6/4/12NR[/TD]
[TD="align: left"]31508[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]11[/TD]
[TD="align: left"]DF 90 MINUTE IPA HD 6/4/12NR[/TD]
[TD="align: left"]31502[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]12[/TD]
[TD="align: left"]DF 90 MINUTE IPA HD 6/4/12NR[/TD]
[TD="align: left"]31502[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]13[/TD]
[TD="align: left"]DF NAMASTE 4/6/12NR[/TD]
[TD="align: left"]31498[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]14[/TD]
[TD="align: left"]DF SEAQUENCH ALE 4/6/12 CAN[/TD]
[TD="align: left"]40023[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]15[/TD]
[TD="align: left"]DF 60 MINUTE IPA 4/6/12NR[/TD]
[TD="align: left"]31494[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]16[/TD]
[TD="align: left"]DF 90 MINUTE IPA HD 6/4/12NR[/TD]
[TD="align: left"]31502[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]17[/TD]
[TD="align: left"]DF BEER TO DRINK MUSIC 4/6/12NR[/TD]
[TD="align: left"]40369[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]18[/TD]
[TD="align: left"]DF FLESH AND BLOOD 4/6/12 CAN[/TD]
[TD="align: left"]40022[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]19[/TD]
[TD="align: left"]DF SAISON DU BUFF 6/4/12 NR[/TD]
[TD="align: left"]40083[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]20[/TD]
[TD="align: left"]DF 120 MINUTE IPA 24/12NR[/TD]
[TD="align: left"]31558[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]21[/TD]
[TD="align: left"]DF MIDAS TOUCH 6/4/12NR[/TD]
[TD="align: left"]31512[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]22[/TD]
[TD="align: left"]DF ROMANTIC CHEMISTRY 4/6/12 NR[/TD]
[TD="align: left"]40718[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]23[/TD]
[TD="align: left"]DF INDIAN BROWN 4/6/12NR[/TD]
[TD="align: left"]31496[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]24[/TD]
[TD="align: left"]DF BURTON 6/4/12NR[/TD]
[TD="align: left"]31506[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]25[/TD]
[TD="align: left"]DF PALO SANTO 6/4/12NR[/TD]
[TD="align: left"]31516[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]26[/TD]
[TD="align: left"]DF LUPU-LUAU IPA 4/6/12 NR[/TD]
[TD="align: left"]40909[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]27[/TD]
[TD="align: left"]DF 60 MINUTE IPA 12/19.2 CAN[/TD]
[TD="align: left"]40587[/TD]
[TD="align: right"]1[/TD]

</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[jarjarbingie]

hello,

i need to fill in a table by matching the vertical number in column j with the horizontal number in row 3 and then entering a 1 if they match or blank if they do not match. I've added a 1 at the intersection of n4 because both the vertical and horizontal numbers are 31494. Table looks like this:
dfw

	i	j	k	l	m	n	o	p	q

<tbody>
[td="align: Center"]1[/td]

[td="colspan: 14, align: Center"]year round[/td]

[td="align: Center"]2[/td]
[td="align: Center"]item names[/td]
[td="align: Center"]item[/td]
[td="align: Center"]90 days[/td]
[td="align: Center"]df 60 minute ipa 12/19.2 can[/td]
[td="align: Center"]df 60 minute ipa 2/12/12 can[/td]
[td="align: Center"]df 60 minute ipa 4/6/12nr[/td]
[td="align: Center"]df 90 minute ipa hd 6/4/12nr[/td]
[td="align: Center"]df burton 6/4/12nr[/td]
[td="align: Center"]df flesh and blood 4/6/12 can[/td]

[td="align: Center"]3[/td]
[td="align: Left"]total[/td]

[td="align: Center"]40587[/td]
[td="align: Center"]39941[/td]
[td="align: Center"]31494[/td]
[td="align: Center"]31502[/td]
[td="align: Center"]31506[/td]
[td="align: Center"]40022[/td]

[td="align: Center"]4[/td]
[td="align: Left"]df 60 minute ipa 4/6/12nr[/td]
[td="align: Left"]31494[/td]
[td="align: Right"]1[/td]

[td="align: Right"]1[/td]

[td="align: Center"]5[/td]
[td="align: Left"]df 60 minute ipa 2/12/12 can[/td]
[td="align: Left"]39941[/td]
[td="align: Right"]1[/td]

[td="align: Center"]6[/td]
[td="align: Left"]df seaquench ale 4/6/12 can[/td]
[td="align: Left"]40023[/td]
[td="align: Right"]1[/td]

[td="align: Center"]7[/td]
[td="align: Left"]df 90 minute ipa hd 6/4/12nr[/td]
[td="align: Left"]31502[/td]
[td="align: Right"]1[/td]

[td="align: Center"]8[/td]
[td="align: Left"]df indian brown 4/6/12nr[/td]
[td="align: Left"]31496[/td]
[td="align: Right"]1[/td]

[td="align: Center"]9[/td]
[td="align: Left"]df romantic chemistry 4/6/12 nr[/td]
[td="align: Left"]40718[/td]
[td="align: Right"]1[/td]

[td="align: Center"]10[/td]
[td="align: Left"]df festina peche 6/4/12nr[/td]
[td="align: Left"]31508[/td]
[td="align: Right"]1[/td]

[td="align: Center"]11[/td]
[td="align: Left"]df 90 minute ipa hd 6/4/12nr[/td]
[td="align: Left"]31502[/td]
[td="align: Right"]1[/td]

[td="align: Center"]12[/td]
[td="align: Left"]df 90 minute ipa hd 6/4/12nr[/td]
[td="align: Left"]31502[/td]
[td="align: Right"]1[/td]

[td="align: Center"]13[/td]
[td="align: Left"]df namaste 4/6/12nr[/td]
[td="align: Left"]31498[/td]
[td="align: Right"]1[/td]

[td="align: Center"]14[/td]
[td="align: Left"]df seaquench ale 4/6/12 can[/td]
[td="align: Left"]40023[/td]
[td="align: Right"]1[/td]

[td="align: Center"]15[/td]
[td="align: Left"]df 60 minute ipa 4/6/12nr[/td]
[td="align: Left"]31494[/td]
[td="align: Right"]1[/td]

[td="align: Center"]16[/td]
[td="align: Left"]df 90 minute ipa hd 6/4/12nr[/td]
[td="align: Left"]31502[/td]
[td="align: Right"]1[/td]

[td="align: Center"]17[/td]
[td="align: Left"]df beer to drink music 4/6/12nr[/td]
[td="align: Left"]40369[/td]
[td="align: Right"]1[/td]

[td="align: Center"]18[/td]
[td="align: Left"]df flesh and blood 4/6/12 can[/td]
[td="align: Left"]40022[/td]
[td="align: Right"]1[/td]

[td="align: Center"]19[/td]
[td="align: Left"]df saison du buff 6/4/12 nr[/td]
[td="align: Left"]40083[/td]
[td="align: Right"]1[/td]

[td="align: Center"]20[/td]
[td="align: Left"]df 120 minute ipa 24/12nr[/td]
[td="align: Left"]31558[/td]
[td="align: Right"]1[/td]

[td="align: Center"]21[/td]
[td="align: Left"]df midas touch 6/4/12nr[/td]
[td="align: Left"]31512[/td]
[td="align: Right"]1[/td]

[td="align: Center"]22[/td]
[td="align: Left"]df romantic chemistry 4/6/12 nr[/td]
[td="align: Left"]40718[/td]
[td="align: Right"]1[/td]

[td="align: Center"]23[/td]
[td="align: Left"]df indian brown 4/6/12nr[/td]
[td="align: Left"]31496[/td]
[td="align: Right"]1[/td]

[td="align: Center"]24[/td]
[td="align: Left"]df burton 6/4/12nr[/td]
[td="align: Left"]31506[/td]
[td="align: Right"]1[/td]

[td="align: Center"]25[/td]
[td="align: Left"]df palo santo 6/4/12nr[/td]
[td="align: Left"]31516[/td]
[td="align: Right"]1[/td]

[td="align: Center"]26[/td]
[td="align: Left"]df lupu-luau ipa 4/6/12 nr[/td]
[td="align: Left"]40909[/td]
[td="align: Right"]1[/td]

[td="align: Center"]27[/td]
[td="align: Left"]df 60 minute ipa 12/19.2 can[/td]
[td="align: Left"]40587[/td]
[td="align: Right"]1[/td]

</tbody>

excel tables to the web >> excel jeanie html 4

=if($j4=n$3,1,"")