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
1				YEAR ROUND
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	DF FLESH AND BLOOD 4/6/12 CAN
3	Total			40587	39941	31494	31502	31506	40022
4	DF 60 MINUTE IPA 4/6/12NR	31494	1			1
5	DF 60 MINUTE IPA 2/12/12 CAN	39941	1
6	DF SEAQUENCH ALE 4/6/12 CAN	40023	1
7	DF 90 MINUTE IPA HD 6/4/12NR	31502	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
12	DF 90 MINUTE IPA HD 6/4/12NR	31502	1
13	DF NAMASTE 4/6/12NR	31498	1
14	DF SEAQUENCH ALE 4/6/12 CAN	40023	1
15	DF 60 MINUTE IPA 4/6/12NR	31494	1
16	DF 90 MINUTE IPA HD 6/4/12NR	31502	1
17	DF BEER TO DRINK MUSIC 4/6/12NR	40369	1
18	DF FLESH AND BLOOD 4/6/12 CAN	40022	1
19	DF SAISON DU BUFF 6/4/12 NR	40083	1
20	DF 120 MINUTE IPA 24/12NR	31558	1
21	DF MIDAS TOUCH 6/4/12NR	31512	1
22	DF ROMANTIC CHEMISTRY 4/6/12 NR	40718	1
23	DF INDIAN BROWN 4/6/12NR	31496	1
24	DF BURTON 6/4/12NR	31506	1
25	DF PALO SANTO 6/4/12NR	31516	1
26	DF LUPU-LUAU IPA 4/6/12 NR	40909	1
27	DF 60 MINUTE IPA 12/19.2 CAN	40587	1

<tbody>
</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
1				year round
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	df flesh and blood 4/6/12 can
3	total			40587	39941	31494	31502	31506	40022
4	df 60 minute ipa 4/6/12nr	31494	1			1
5	df 60 minute ipa 2/12/12 can	39941	1
6	df seaquench ale 4/6/12 can	40023	1
7	df 90 minute ipa hd 6/4/12nr	31502	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
12	df 90 minute ipa hd 6/4/12nr	31502	1
13	df namaste 4/6/12nr	31498	1
14	df seaquench ale 4/6/12 can	40023	1
15	df 60 minute ipa 4/6/12nr	31494	1
16	df 90 minute ipa hd 6/4/12nr	31502	1
17	df beer to drink music 4/6/12nr	40369	1
18	df flesh and blood 4/6/12 can	40022	1
19	df saison du buff 6/4/12 nr	40083	1
20	df 120 minute ipa 24/12nr	31558	1
21	df midas touch 6/4/12nr	31512	1
22	df romantic chemistry 4/6/12 nr	40718	1
23	df indian brown 4/6/12nr	31496	1
24	df burton 6/4/12nr	31506	1
25	df palo santo 6/4/12nr	31516	1
26	df lupu-luau ipa 4/6/12 nr	40909	1
27	df 60 minute ipa 12/19.2 can	40587	1

<tbody>
</tbody>

excel tables to the web >> excel jeanie html 4

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