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

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:249px;"><col style="width:47px;"><col style="width:52px;"><col style="width:93px;"><col style="width:79px;"><col style="width:79px;"><col style="width:79px;"><col style="width:79px;"><col style="width:79px;"></colgroup><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

 

[AhoyNC]

See if this does what you want.
Copy formula across and down as needed.

Excel Workbook
	I	J	K	L	M	N	O	P
1				YEAR ROUND		TRUE
2	Item Names	ITEM	90 Days	DF 60 MINUTE IPA 12/19.2 CAN	DF 60 MINUTE IPA 2/12/12 CAN	DF 60 MINUTE IPA 4/6/12NR	DF 90 MINUTE IPA HD 6/4/12NR	DF BURTON 6/4/12NR
3	Total			40587	39941	31494	31502	31506
4	DF 60 MINUTE IPA 4/6/12NR	31494	1			1
5	DF 60 MINUTE IPA 2/12/12 CAN	39941	1		1
6	DF SEAQUENCH ALE 4/6/12 CAN	40023	1
7	DF 90 MINUTE IPA HD 6/4/12NR	31502	1				1
8	DF INDIAN BROWN 4/6/12NR	31496	1
9	DF ROMANTIC CHEMISTRY 4/6/12 NR	40718	1
10	DF FESTINA PECHE 6/4/12NR	31508	1
11	DF 90 MINUTE IPA HD 6/4/12NR	31502	1				1
12	DF 90 MINUTE IPA HD 6/4/12NR	31502	1				1
13	DF NAMASTE 4/6/12NR	31498	1
Sheet

 

[gutie049]

This is perfect! Thank you!

 

[AhoyNC]

You're welcome. Thanks for the feedback.