Filter question

[angleright]

I am trying to filter on a column(column "L",Plan No) with the following formula
=IF(R18="","",FILTER(FILTER($H$2:$N$109,($L$2:$L$109=$R$18),"NOTHING FOUND"),{0,0,0,0,0,0,1}))
the filter returns work great if the cell contains a number and letter but returns nothing if the cell only contains a number. I have the cells formatted as text. I've tried formatting as general and numeric but still get the same results.
the formula is in row w59

 

[angleright]

Sorry again i put a an alpha numeric value in R18, thats the search criteria and i put some numeric values in as well. this file has almost 7000 rows and most of the numeric values are way down the list, and XL2BB wont let me get that far down to include them

BETA FILE.xlsm
	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
2	001	BLDG DEPT	2960	BAILEY RD		A	\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2960 BAILEY RD A.PDF	Open		NO. OF SCANNED BOXES
3	001	BLDG DEPT	2960	BAILEY RD		B	\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2960 BAILEY RD B.PDF	Open			76
4	001	BLDG DEPT	2916	OAKWOOD DR	A-9-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2916 OAKWOOD DR.PDF	Open
5	001	BLDG DEPT	2819	HUDSON DR	A-2-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2819 HUDSON DR.PDF	Open
6	001	BLDG DEPT	2231	BROAD BLVD	A-10-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2231 BROAD BLVD.PDF	Open
7	001	BLDG DEPT	2121	6TH ST	A-11-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2121 6TH ST.PDF	Open
8	001	BLDG DEPT	2114	FRONT ST	A-8-R	A	\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2114 FRONT ST A.PDF	Open			SEARCH BY ADDRESS (MUST BE EXACT MATCH)
9	001	BLDG DEPT	2114	FRONT ST	A-8-R	B	\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2114 FRONT ST B.PDF	Open			ENTER ST NO.	ENTER ST. NAME
10	001	BLDG DEPT	210	BROADWAY EAST	A-7-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 210 BROADWAY EAST.PDF	Open						0
11	001	BLDG DEPT	210	E BROADWAY	A-6-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 210 E BROADWAY.PDF	Open
12	001	BLDG DEPT	1640	STATE RD	A-1-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 1640 STATE RD.PDF	Open
13	001	BLDG DEPT	1305	MONROE FALLS AVE	A-12-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 1305 MONROE FALLS AVE.PDF	Open
14	001	BLDG DEPT	117	PORTAGE TRL	A-5-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 117 PORTAGE TRL.PDF	Open
15	001	BLDG DEPT		CITY SERVICE OIL CO	A-3-R	A	\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT CITY SERVICE OIL CO A.PDF	Open
16	001	BLDG DEPT		CITY SERVICE OIL CO	A-3-R	B	\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT CITY SERVICE OIL CO B.PDF	Open			SEARCH BY PLAN NO.
17	002	BLDG DEPT	507	MONROE FALLS AVE	A-17-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 507 MONROE FALLS AVE.PDF	Open			ENTER PLAN NO.
18	002	BLDG DEPT	2686	FRONT ST	A-13-R	A	\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 2686 FRONT ST A.PDF	Open			1635-b				\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT NEWBERRY SCHOOL A.PDF
19	002	BLDG DEPT	2686	FRONT ST	A-13-R	B	\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 2686 FRONT ST B.PDF	Open			OPEN
20	002	BLDG DEPT	2307	SACKETT ST	A-19-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 2307 SACKETT ST.PDF	Open			SEARCH BY NAME ONLY(I.E., "FRATERNAL ORDER OF EAGLES")
21	002	BLDG DEPT	2231	BROAD BLVD	A-21-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 2231 BROAD BLVD.PDF	Open			FOR WILD CARD USE "*"
22	002	BLDG DEPT	2063	FRONT ST	A-18-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 2063 FRONT ST.PDF	Open			ENTER NAME
23	002	BLDG DEPT	1916	HIGHBRIDGE RD	A-16-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 1916 HIGHBRIDGE RD.PDF	Open
24	002	BLDG DEPT	1787	STATE RD	A-20-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 1787 STATE RD.PDF	Open
25	002	BLDG DEPT	1752	WILLIAMS ST	A-15-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 1752 WILLIAMS ST.PDF	Open
26	002	BLDG DEPT	1225	MONROE FALLS AVE	C-6705		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 1225 MONROE FALLS AVE.PDF	Open
27	002	BLDG DEPT		STATE RD AND CHESTNUT BLVD	A-14-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT STATE RD AND CHESTNUT BLVD.PDF	Open			SEARCH RESULTS BY ADDRESS
28	002	BLDG DEPT		FRATERNAL ORDER OF EAGLES	A-22-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT FRATERNAL ORDER OF EAGLES.PDF	Open
29	003	BLDG DEPT	800	TALLMADGE RD	A-29-R	A	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT 800 TALLMADGE RD A.PDF	Open			BOX NO.	SEARCH RESULTS FOR			RETURN CONVERTED TO TEXT	FILTER RETURN
30	003	BLDG DEPT	800	TALLMADGE RD	A-29-R	B	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT 800 TALLMADGE RD B.PDF	Open							#VALUE!	#VALUE!
31	003	BLDG DEPT	3131	W BAILEY RD	A-28-R		\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT 3131 W BAILEY RD.PDF	Open
32	003	BLDG DEPT	2300	4TH ST	A-27-R		\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT 2300 4TH ST.PDF	Open
33	003	BLDG DEPT	1910	SEARL ST	A-26-R		\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT 1910 SEARL ST.PDF	Open
34	003	BLDG DEPT		YMCA		A	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT YMCA A.PDF	Open
35	003	BLDG DEPT		NEWBERRY SCHOOL	1635-b	A	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT NEWBERRY SCHOOL A.PDF	Open
36	003	BLDG DEPT		ELIZABETH PRICE SCHOOL	2297	A	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT ELIZABETH PRICE SCHOOL A.PDF	Open
37	003	BLDG DEPT		CRAWFORD SCHOOL	4453	A	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT CRAWFORD SCHOOL A.PDF	Open
38	003	BLDG DEPT		YMCA	65	B	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT YMCA B.PDF	Open
39	003	BLDG DEPT		NEWBERRY SCHOOL	129	B	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT NEWBERRY SCHOOL B.PDF	Open
40	003	BLDG DEPT		ELIZABETH PRICE SCHOOL		B	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT ELIZABETH PRICE SCHOOL B.PDF	Open
41	003	BLDG DEPT		CRAWFORD SCHOOL		B	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT CRAWFORD SCHOOL B.PDF	Open
42	003	BLDG DEPT		NEWBERRY SCHOOL		C	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT NEWBERRY SCHOOL C.PDF	Open
43	003	BLDG DEPT		ELIZABETH PRICE SCHOOL		C	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT ELIZABETH PRICE SCHOOL C.PDF	Open
44	003	BLDG DEPT		SILL SCHOOL PLUMBING			\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT SILL SCHOOL PLUMBING.PDF	Open
45	004	BLDG DEPT	355	PORTAGE TRL	A-33-R		\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT 355 PORTAGE TRL.PDF	Open
46	004	BLDG DEPT	2916	OAKWOOD DR	A-39-R		\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT 2916 OAKWOOD DR.PDF	Open
47	004	BLDG DEPT	2834	2ND ST	A-35-R		\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT 2834 2ND ST.PDF	Open
48	004	BLDG DEPT	2735	FRONT ST	A-38-R	A	\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT 2735 FRONT ST A.PDF	Open
49	004	BLDG DEPT	2735	FRONT ST	A-38-R	B	\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT 2735 FRONT ST B.PDF	Open
50	004	BLDG DEPT	2421	STATE RD	A-37-R		\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT 2421 STATE RD.PDF	Open
51	004	BLDG DEPT	1850	STATE RD	A-36-R	A	\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT 1850 STATE RD A.PDF	Open
52	004	BLDG DEPT	1850	STATE RD	A-36-R	B	\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT 1850 STATE RD B.PDF	Open
53	004	BLDG DEPT	1850	STATE RD	A-36-R	C	\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT 1850 STATE RD C.PDF	Open
54	004	BLDG DEPT	1850	STATE RD	A-36-R	D	\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT 1850 STATE RD D.PDF	Open
55	004	BLDG DEPT		STATE RD AND CHAMBERLIN	A-41-R	A	\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT STATE RD AND CHAMBERLIN A.PDF	Open			SEARCH RESULTS BY PLAN NO.
56	004	BLDG DEPT		STATE RD AND CHAMBERLIN	A-41-R	B	\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT STATE RD AND CHAMBERLIN B.PDF	Open
57	004	BLDG DEPT		STATE RD AND FALLS ST			\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT STATE RD AND FALLS ST.PDF	Open			BOX NO.	SEARCH RESULTS FOR
58	004	BLDG DEPT		FRATERNAL ORDER OF EAGLES	A-34-R		\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT FRATERNAL ORDER OF EAGLES.PDF	Open				1635-b
59	005	BLDG DEPT	807	WASHINGTON	A-75		\\CF-FILE04\Engineering\ScanWorks\005 BLDG DEPT 807 WASHINGTON.PDF	Open							RETURN CONVERTED TO TEXT	FILTER RETURN
60	005	BLDG DEPT	739	PORTAGE TRL			\\CF-FILE04\Engineering\ScanWorks\005 BLDG DEPT 739 PORTAGE TRL.PDF	Open			003	OPEN			\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT NEWBERRY SCHOOL A.PDF	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT NEWBERRY SCHOOL A.PDF
61	005	BLDG DEPT	739	ROOSEVELT	A-55		\\CF-FILE04\Engineering\ScanWorks\005 BLDG DEPT 739 ROOSEVELT.PDF	Open
62	005	BLDG DEPT	735	LEAVITT	A-71		\\CF-FILE04\Engineering\ScanWorks\005 BLDG DEPT 735 LEAVITT.PDF	Open
63	005	BLDG DEPT	712	ALAMEDA	A-45		\\CF-FILE04\Engineering\ScanWorks\005 BLDG DEPT 712 ALAMEDA.PDF	Open
64	005	BLDG DEPT	650	GRAHAM RD	A-81		\\CF-FILE04\Engineering\ScanWorks\005 BLDG DEPT 650 GRAHAM RD.PDF	Open
65	005	BLDG DEPT	518	GROVE	A-56		\\CF-FILE04\Engineering\ScanWorks\005 BLDG DEPT 518 GROVE.PDF	Open
66	005	BLDG DEPT	513	MAGNOLIA	A-63		\\CF-FILE04\Engineering\ScanWorks\005 BLDG DEPT 513 MAGNOLIA.PDF	Open
CCFTABLE

Cell Formulas
Range	Formula
N2:N3,N8:N9,N18:N19,N29:N30,N48:N49,N51:N54	N2	=HYPERLINK(CONCATENATE($P$1&H2&I2& J2&" "&K2&" "&M2&".PDF"))
O2:O66	O2	=HYPERLINK(N2,"Open")
N4:N7,N10:N13,N17,N20:N26,N31:N33,N45:N47,N50,N59:N66	N4	=HYPERLINK(CONCATENATE($P$1&H4&I4& J4&" "&K4&M4&".PDF"))
N14	N14	=HYPERLINK(CONCATENATE($P$1&H14&I14&J14&" "&K14&M14&".PDF"))
N15:N16,N34:N43,N55:N56	N15	=HYPERLINK(CONCATENATE($P$1&H15&I15& J15&K15&" "&M15&".PDF"))
N27:N28,N44,N57:N58	N27	=HYPERLINK(CONCATENATE($P$1&H27&I27&K27&".PDF"))
R3	R3	=SHEETS()-2
U10	U10	=INDEX(N:N,MATCH(1,(R10=J:J)*(S10=K:K),0),1)
V18	V18	=VLOOKUP($R$18,$L$2:$N$6895,3,FALSE)
R19	R19	=IF(R18="","",HYPERLINK(V18,"OPEN"))
U23	U23	=IF(R23="","",VLOOKUP(R23&"*",K2:N6895,4,FALSE))
R24	R24	=IF(R23="","",HYPERLINK(U23,"OPEN"))
R30	R30	=IF(S10="","",FILTER(FILTER($H$2:$N$6895,($K$2:$K$6895=$S$10)*($J$2:$J$6895=$R$10),"NOTHING FOUND"),{1,0,0,0,0,0,0}))
W30	W30	=FILTER(FILTER($H$2:$N$6895,($K$2:$K$6895=$S$10)*($J$2:$J$6895=$R$10),"NOTHING FOUND"),{0,0,0,0,0,0,1})
S30	S30	=IF(S10="","",(HYPERLINK(V30,"OPEN")))
S31:S54,S60:S66	S31	=IF(V31="","",(HYPERLINK(V31,"OPEN")))
S58	S58	=IF(R18="","",R18)
V30:V58,V60:V66	V30	=IF(W30="","",ARRAYTOTEXT(W30))
R60	R60	=IF(R18="","",FILTER(FILTER($H$2:$N$6895,($L$2:$L$6895=$R$18),"NOTHING FOUND"),{1,0,0,0,0,0,0}))
W60	W60	=IF(R18="","",FILTER(FILTER($H$2:$N$6895,($L$2:$L$6895=$R$18),"NOTHING FOUND"),{0,0,0,0,0,0,1}))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H2:O2	Expression	=MOD(ROW(),2)=1	text	NO
H2:O2	Expression	=MOD(ROW(),2)=1	text	NO
H2:P2	Expression	=MOD(ROW(),2)=1	text	NO
H3:O3	Expression	=MOD(ROW(),2)=1	text	NO
H3:O3	Expression	=MOD(ROW(),2)=1	text	NO
H3:P3	Expression	=MOD(ROW(),2)=1	text	NO
H4:O1900,H1901:K2361,M1901:O2361,H2362:O5465,H5286:H5551	Expression	=MOD(ROW(),2)=1	text	NO
H4:O1900,H1901:K2361,M1901:O2361,H2362:O5465,H5286:H5551	Expression	=MOD(ROW(),2)=1	text	NO
H4:P1900,H5908:O5908,H5924:O5924,H5958:O5958,H5870:O5870,H5872:O5872,H5874:O5874,H5876:O5876,H5878:O5878,H5880:O5880,H5882:O5882,H5884:O5884,H5886:O5886,H5888:O5888,H5890:O5890,H5892:O5892,H5894:O5894,H5896:O5896,H5898:O5898,H5900:O5900,H5902:O5902	Expression	=MOD(ROW(),2)=1	text	NO

 

[Fluff]

Can you show me the formula not working, as it works fine if I change R18 to 65

 

[angleright]

Weird, it doesn't work for me

BETA FILE.xlsm
	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	BOX	BLDG DEPT	ADDRESS	STREET	PLAN NO	PART NO	N	O	\\CF-FILE04\Engineering\ScanWorks\
2	001	BLDG DEPT	2960	BAILEY RD		A	\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2960 BAILEY RD A.PDF	Open		NO. OF SCANNED BOXES
3	001	BLDG DEPT	2960	BAILEY RD		B	\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2960 BAILEY RD B.PDF	Open			76
4	001	BLDG DEPT	2916	OAKWOOD DR	A-9-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2916 OAKWOOD DR.PDF	Open
5	001	BLDG DEPT	2819	HUDSON DR	A-2-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2819 HUDSON DR.PDF	Open
6	001	BLDG DEPT	2231	BROAD BLVD	A-10-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2231 BROAD BLVD.PDF	Open
7	001	BLDG DEPT	2121	6TH ST	A-11-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2121 6TH ST.PDF	Open
8	001	BLDG DEPT	2114	FRONT ST	A-8-R	A	\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2114 FRONT ST A.PDF	Open			SEARCH BY ADDRESS (MUST BE EXACT MATCH)
9	001	BLDG DEPT	2114	FRONT ST	A-8-R	B	\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2114 FRONT ST B.PDF	Open			ENTER ST NO.	ENTER ST. NAME
10	001	BLDG DEPT	210	BROADWAY EAST	A-7-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 210 BROADWAY EAST.PDF	Open
11	001	BLDG DEPT	210	E BROADWAY	A-6-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 210 E BROADWAY.PDF	Open
12	001	BLDG DEPT	1640	STATE RD	A-1-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 1640 STATE RD.PDF	Open
13	001	BLDG DEPT	1305	MONROE FALLS AVE	A-12-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 1305 MONROE FALLS AVE.PDF	Open
14	001	BLDG DEPT	117	PORTAGE TRL	A-5-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 117 PORTAGE TRL.PDF	Open
15	001	BLDG DEPT		CITY SERVICE OIL CO	A-3-R	A	\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT CITY SERVICE OIL CO A.PDF	Open
16	001	BLDG DEPT		CITY SERVICE OIL CO	A-3-R	B	\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT CITY SERVICE OIL CO B.PDF	Open			SEARCH BY PLAN NO.
17	002	BLDG DEPT	507	MONROE FALLS AVE	A-17-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 507 MONROE FALLS AVE.PDF	Open			ENTER PLAN NO.
18	002	BLDG DEPT	2686	FRONT ST	A-13-R	A	\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 2686 FRONT ST A.PDF	Open			65
19	002	BLDG DEPT	2686	FRONT ST	A-13-R	B	\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 2686 FRONT ST B.PDF	Open			#N/A
20	002	BLDG DEPT	2307	SACKETT ST	A-19-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 2307 SACKETT ST.PDF	Open			SEARCH BY NAME ONLY(I.E., "FRATERNAL ORDER OF EAGLES")
21	002	BLDG DEPT	2231	BROAD BLVD	A-21-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 2231 BROAD BLVD.PDF	Open			FOR WILD CARD USE "*"
22	002	BLDG DEPT	2063	FRONT ST	A-18-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 2063 FRONT ST.PDF	Open			ENTER NAME
23	002	BLDG DEPT	1916	HIGHBRIDGE RD	A-16-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 1916 HIGHBRIDGE RD.PDF	Open
24	002	BLDG DEPT	1787	STATE RD	A-20-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 1787 STATE RD.PDF	Open
25	002	BLDG DEPT	1752	WILLIAMS ST	A-15-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 1752 WILLIAMS ST.PDF	Open
26	002	BLDG DEPT	1225	MONROE FALLS AVE	C-6705		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 1225 MONROE FALLS AVE.PDF	Open
27	002	BLDG DEPT		STATE RD AND CHESTNUT BLVD	A-14-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT STATE RD AND CHESTNUT BLVD.PDF	Open			SEARCH RESULTS BY ADDRESS
28	002	BLDG DEPT		FRATERNAL ORDER OF EAGLES	A-22-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT FRATERNAL ORDER OF EAGLES.PDF	Open
29	003	BLDG DEPT	800	TALLMADGE RD	A-29-R	A	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT 800 TALLMADGE RD A.PDF	Open			BOX NO.	SEARCH RESULTS FOR
30	003	BLDG DEPT	800	TALLMADGE RD	A-29-R	B	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT 800 TALLMADGE RD B.PDF	Open
31	003	BLDG DEPT	3131	W BAILEY RD	A-28-R		\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT 3131 W BAILEY RD.PDF	Open
32	003	BLDG DEPT	2300	4TH ST	A-27-R		\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT 2300 4TH ST.PDF	Open
33	003	BLDG DEPT	1910	SEARL ST	A-26-R		\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT 1910 SEARL ST.PDF	Open
34	003	BLDG DEPT		YMCA		A	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT YMCA A.PDF	Open
35	003	BLDG DEPT		NEWBERRY SCHOOL	1635-b	A	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT NEWBERRY SCHOOL A.PDF	Open
36	003	BLDG DEPT		ELIZABETH PRICE SCHOOL	2297	A	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT ELIZABETH PRICE SCHOOL A.PDF	Open
37	003	BLDG DEPT		CRAWFORD SCHOOL	4453	A	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT CRAWFORD SCHOOL A.PDF	Open
38	003	BLDG DEPT		YMCA	65	B	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT YMCA B.PDF	Open
39	003	BLDG DEPT		NEWBERRY SCHOOL	129	B	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT NEWBERRY SCHOOL B.PDF	Open
40	003	BLDG DEPT		ELIZABETH PRICE SCHOOL		B	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT ELIZABETH PRICE SCHOOL B.PDF	Open
CCFTABLE

Cell Formulas
Range	Formula
N2:N3,N8:N9,N18:N19,N29:N30	N2	=HYPERLINK(CONCATENATE($P$1&H2&I2& J2&" "&K2&" "&M2&".PDF"))
O2:O40	O2	=HYPERLINK(N2,"Open")
N4:N7,N10:N13,N17,N20:N26,N31:N33	N4	=HYPERLINK(CONCATENATE($P$1&H4&I4& J4&" "&K4&M4&".PDF"))
N14	N14	=HYPERLINK(CONCATENATE($P$1&H14&I14&J14&" "&K14&M14&".PDF"))
N15:N16,N34:N40	N15	=HYPERLINK(CONCATENATE($P$1&H15&I15& J15&K15&" "&M15&".PDF"))
N27:N28	N27	=HYPERLINK(CONCATENATE($P$1&H27&I27&K27&".PDF"))
R3	R3	=SHEETS()-2
R19	R19	=IF(R18="","",HYPERLINK(V18,"OPEN"))
R24	R24	=IF(R23="","",HYPERLINK(U23,"OPEN"))
R30	R30	=IF(S10="","",FILTER(FILTER($H$2:$N$6895,($K$2:$K$6895=$S$10)*($J$2:$J$6895=$R$10),"NOTHING FOUND"),{1,0,0,0,0,0,0}))
S30	S30	=IF(S10="","",(HYPERLINK(V30,"OPEN")))
S31:S40	S31	=IF(V31="","",(HYPERLINK(V31,"OPEN")))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H2:O2	Expression	=MOD(ROW(),2)=1	text	NO
H2:O2	Expression	=MOD(ROW(),2)=1	text	NO
H2:P2	Expression	=MOD(ROW(),2)=1	text	NO
H3:O3	Expression	=MOD(ROW(),2)=1	text	NO
H3:O3	Expression	=MOD(ROW(),2)=1	text	NO
H3:P3	Expression	=MOD(ROW(),2)=1	text	NO
H4:O1900,H1901:K2361,M1901:O2361,H2362:O5465,H5286:H5551	Expression	=MOD(ROW(),2)=1	text	NO
H4:O1900,H1901:K2361,M1901:O2361,H2362:O5465,H5286:H5551	Expression	=MOD(ROW(),2)=1	text	NO
H4:P1900,H5908:O5908,H5924:O5924,H5958:O5958,H5870:O5870,H5872:O5872,H5874:O5874,H5876:O5876,H5878:O5878,H5880:O5880,H5882:O5882,H5884:O5884,H5886:O5886,H5888:O5888,H5890:O5890,H5892:O5892,H5894:O5894,H5896:O5896,H5898:O5898,H5900:O5900,H5902:O5902	Expression	=MOD(ROW(),2)=1	text	NO

 

[Fluff]

That doesn't show the formula

 

[angleright]

Just so you know, I appreciate all your efforts

BETA FILE.xlsm
	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	BOX	BLDG DEPT	ADDRESS	STREET	PLAN NO	PART NO	N	O	\\CF-FILE04\Engineering\ScanWorks\
2	001	BLDG DEPT	2960	BAILEY RD		A	\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2960 BAILEY RD A.PDF	Open		NO. OF SCANNED BOXES
3	001	BLDG DEPT	2960	BAILEY RD		B	\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2960 BAILEY RD B.PDF	Open			76
4	001	BLDG DEPT	2916	OAKWOOD DR	A-9-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2916 OAKWOOD DR.PDF	Open
5	001	BLDG DEPT	2819	HUDSON DR	A-2-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2819 HUDSON DR.PDF	Open
6	001	BLDG DEPT	2231	BROAD BLVD	A-10-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2231 BROAD BLVD.PDF	Open
7	001	BLDG DEPT	2121	6TH ST	A-11-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2121 6TH ST.PDF	Open
8	001	BLDG DEPT	2114	FRONT ST	A-8-R	A	\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2114 FRONT ST A.PDF	Open			SEARCH BY ADDRESS (MUST BE EXACT MATCH)
9	001	BLDG DEPT	2114	FRONT ST	A-8-R	B	\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2114 FRONT ST B.PDF	Open			ENTER ST NO.	ENTER ST. NAME
10	001	BLDG DEPT	210	BROADWAY EAST	A-7-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 210 BROADWAY EAST.PDF	Open						0
11	001	BLDG DEPT	210	E BROADWAY	A-6-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 210 E BROADWAY.PDF	Open
12	001	BLDG DEPT	1640	STATE RD	A-1-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 1640 STATE RD.PDF	Open
13	001	BLDG DEPT	1305	MONROE FALLS AVE	A-12-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 1305 MONROE FALLS AVE.PDF	Open
14	001	BLDG DEPT	117	PORTAGE TRL	A-5-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 117 PORTAGE TRL.PDF	Open
15	001	BLDG DEPT		CITY SERVICE OIL CO	A-3-R	A	\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT CITY SERVICE OIL CO A.PDF	Open
16	001	BLDG DEPT		CITY SERVICE OIL CO	A-3-R	B	\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT CITY SERVICE OIL CO B.PDF	Open			SEARCH BY PLAN NO.
17	002	BLDG DEPT	507	MONROE FALLS AVE	A-17-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 507 MONROE FALLS AVE.PDF	Open			ENTER PLAN NO.
18	002	BLDG DEPT	2686	FRONT ST	A-13-R	A	\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 2686 FRONT ST A.PDF	Open			65				#N/A
19	002	BLDG DEPT	2686	FRONT ST	A-13-R	B	\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 2686 FRONT ST B.PDF	Open			#N/A
20	002	BLDG DEPT	2307	SACKETT ST	A-19-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 2307 SACKETT ST.PDF	Open			SEARCH BY NAME ONLY(I.E., "FRATERNAL ORDER OF EAGLES")
21	002	BLDG DEPT	2231	BROAD BLVD	A-21-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 2231 BROAD BLVD.PDF	Open			FOR WILD CARD USE "*"
22	002	BLDG DEPT	2063	FRONT ST	A-18-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 2063 FRONT ST.PDF	Open			ENTER NAME
23	002	BLDG DEPT	1916	HIGHBRIDGE RD	A-16-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 1916 HIGHBRIDGE RD.PDF	Open
24	002	BLDG DEPT	1787	STATE RD	A-20-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 1787 STATE RD.PDF	Open
25	002	BLDG DEPT	1752	WILLIAMS ST	A-15-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 1752 WILLIAMS ST.PDF	Open
26	002	BLDG DEPT	1225	MONROE FALLS AVE	C-6705		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 1225 MONROE FALLS AVE.PDF	Open
27	002	BLDG DEPT		STATE RD AND CHESTNUT BLVD	A-14-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT STATE RD AND CHESTNUT BLVD.PDF	Open			SEARCH RESULTS BY ADDRESS
28	002	BLDG DEPT		FRATERNAL ORDER OF EAGLES	A-22-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT FRATERNAL ORDER OF EAGLES.PDF	Open
29	003	BLDG DEPT	800	TALLMADGE RD	A-29-R	A	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT 800 TALLMADGE RD A.PDF	Open			BOX NO.	SEARCH RESULTS FOR			RETURN CONVERTED TO TEXT	FILTER RETURN
30	003	BLDG DEPT	800	TALLMADGE RD	A-29-R	B	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT 800 TALLMADGE RD B.PDF	Open							#VALUE!	#VALUE!
31	003	BLDG DEPT	3131	W BAILEY RD	A-28-R		\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT 3131 W BAILEY RD.PDF	Open
32	003	BLDG DEPT	2300	4TH ST	A-27-R		\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT 2300 4TH ST.PDF	Open
33	003	BLDG DEPT	1910	SEARL ST	A-26-R		\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT 1910 SEARL ST.PDF	Open
34	003	BLDG DEPT		YMCA		A	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT YMCA A.PDF	Open
35	003	BLDG DEPT		NEWBERRY SCHOOL	1635-b	A	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT NEWBERRY SCHOOL A.PDF	Open
36	003	BLDG DEPT		ELIZABETH PRICE SCHOOL	2297	A	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT ELIZABETH PRICE SCHOOL A.PDF	Open
37	003	BLDG DEPT		CRAWFORD SCHOOL	4453	A	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT CRAWFORD SCHOOL A.PDF	Open
38	003	BLDG DEPT		YMCA	65	B	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT YMCA B.PDF	Open
39	003	BLDG DEPT		NEWBERRY SCHOOL	129	B	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT NEWBERRY SCHOOL B.PDF	Open
40	003	BLDG DEPT		ELIZABETH PRICE SCHOOL		B	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT ELIZABETH PRICE SCHOOL B.PDF	Open
41	003	BLDG DEPT		CRAWFORD SCHOOL		B	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT CRAWFORD SCHOOL B.PDF	Open
CCFTABLE

Cell Formulas
Range	Formula
N2:N3,N8:N9,N18:N19,N29:N30	N2	=HYPERLINK(CONCATENATE($P$1&H2&I2& J2&" "&K2&" "&M2&".PDF"))
O2:O41	O2	=HYPERLINK(N2,"Open")
N4:N7,N10:N13,N17,N20:N26,N31:N33	N4	=HYPERLINK(CONCATENATE($P$1&H4&I4& J4&" "&K4&M4&".PDF"))
N14	N14	=HYPERLINK(CONCATENATE($P$1&H14&I14&J14&" "&K14&M14&".PDF"))
N15:N16,N34:N41	N15	=HYPERLINK(CONCATENATE($P$1&H15&I15& J15&K15&" "&M15&".PDF"))
N27:N28	N27	=HYPERLINK(CONCATENATE($P$1&H27&I27&K27&".PDF"))
R3	R3	=SHEETS()-2
U10	U10	=INDEX(N:N,MATCH(1,(R10=J:J)*(S10=K:K),0),1)
V18	V18	=VLOOKUP($R$18,$L$2:$N$6895,3,FALSE)
R19	R19	=IF(R18="","",HYPERLINK(V18,"OPEN"))
U23	U23	=IF(R23="","",VLOOKUP(R23&"*",K2:N6895,4,FALSE))
R24	R24	=IF(R23="","",HYPERLINK(U23,"OPEN"))
R30	R30	=IF(S10="","",FILTER(FILTER($H$2:$N$6895,($K$2:$K$6895=$S$10)*($J$2:$J$6895=$R$10),"NOTHING FOUND"),{1,0,0,0,0,0,0}))
W30	W30	=FILTER(FILTER($H$2:$N$6895,($K$2:$K$6895=$S$10)*($J$2:$J$6895=$R$10),"NOTHING FOUND"),{0,0,0,0,0,0,1})
S30	S30	=IF(S10="","",(HYPERLINK(V30,"OPEN")))
S31:S41	S31	=IF(V31="","",(HYPERLINK(V31,"OPEN")))
V30:V41	V30	=IF(W30="","",ARRAYTOTEXT(W30))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H2:O2	Expression	=MOD(ROW(),2)=1	text	NO
H2:O2	Expression	=MOD(ROW(),2)=1	text	NO
H2:P2	Expression	=MOD(ROW(),2)=1	text	NO
H3:O3	Expression	=MOD(ROW(),2)=1	text	NO
H3:O3	Expression	=MOD(ROW(),2)=1	text	NO
H3:P3	Expression	=MOD(ROW(),2)=1	text	NO
H4:O1900,H1901:K2361,M1901:O2361,H2362:O5465,H5286:H5551	Expression	=MOD(ROW(),2)=1	text	NO
H4:O1900,H1901:K2361,M1901:O2361,H2362:O5465,H5286:H5551	Expression	=MOD(ROW(),2)=1	text	NO
H4:P1900,H5908:O5908,H5924:O5924,H5958:O5958,H5870:O5870,H5872:O5872,H5874:O5874,H5876:O5876,H5878:O5878,H5880:O5880,H5882:O5882,H5884:O5884,H5886:O5886,H5888:O5888,H5890:O5890,H5892:O5892,H5894:O5894,H5896:O5896,H5898:O5898,H5900:O5900,H5902:O5902	Expression	=MOD(ROW(),2)=1	text	NO

 

[Fluff]

Unfortunately, that still does not show the formula

 

[angleright]

Holly S&^t, my bad

BETA FILE.xlsm
	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	Column1	Column2	Column3	Column4	Column5	Column6	Column7	BOX	BLDG DEPT	ADDRESS	STREET	PLAN NO	PART NO	N	O	\\CF-FILE04\Engineering\ScanWorks\
2	001	BLDG DEPT	2960	BAILEY RD		A	\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2960 BAILEY RD A.PDF	Open		NO. OF SCANNED BOXES
3	001	BLDG DEPT	2960	BAILEY RD		B	\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2960 BAILEY RD B.PDF	Open			76
4	001	BLDG DEPT	2916	OAKWOOD DR	A-9-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2916 OAKWOOD DR.PDF	Open
5	001	BLDG DEPT	2819	HUDSON DR	A-2-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2819 HUDSON DR.PDF	Open
6	001	BLDG DEPT	2231	BROAD BLVD	A-10-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2231 BROAD BLVD.PDF	Open
7	001	BLDG DEPT	2121	6TH ST	A-11-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2121 6TH ST.PDF	Open
8	001	BLDG DEPT	2114	FRONT ST	A-8-R	A	\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2114 FRONT ST A.PDF	Open			SEARCH BY ADDRESS (MUST BE EXACT MATCH)
9	001	BLDG DEPT	2114	FRONT ST	A-8-R	B	\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 2114 FRONT ST B.PDF	Open			ENTER ST NO.	ENTER ST. NAME
10	001	BLDG DEPT	210	BROADWAY EAST	A-7-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 210 BROADWAY EAST.PDF	Open						0
11	001	BLDG DEPT	210	E BROADWAY	A-6-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 210 E BROADWAY.PDF	Open
12	001	BLDG DEPT	1640	STATE RD	A-1-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 1640 STATE RD.PDF	Open
13	001	BLDG DEPT	1305	MONROE FALLS AVE	A-12-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 1305 MONROE FALLS AVE.PDF	Open
14	001	BLDG DEPT	117	PORTAGE TRL	A-5-R		\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT 117 PORTAGE TRL.PDF	Open
15	001	BLDG DEPT		CITY SERVICE OIL CO	A-3-R	A	\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT CITY SERVICE OIL CO A.PDF	Open
16	001	BLDG DEPT		CITY SERVICE OIL CO	A-3-R	B	\\CF-FILE04\Engineering\ScanWorks\001 BLDG DEPT CITY SERVICE OIL CO B.PDF	Open			SEARCH BY PLAN NO.
17	002	BLDG DEPT	507	MONROE FALLS AVE	A-17-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 507 MONROE FALLS AVE.PDF	Open			ENTER PLAN NO.
18	002	BLDG DEPT	2686	FRONT ST	A-13-R	A	\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 2686 FRONT ST A.PDF	Open			65				#N/A
19	002	BLDG DEPT	2686	FRONT ST	A-13-R	B	\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 2686 FRONT ST B.PDF	Open			#N/A
20	002	BLDG DEPT	2307	SACKETT ST	A-19-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 2307 SACKETT ST.PDF	Open			SEARCH BY NAME ONLY(I.E., "FRATERNAL ORDER OF EAGLES")
21	002	BLDG DEPT	2231	BROAD BLVD	A-21-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 2231 BROAD BLVD.PDF	Open			FOR WILD CARD USE "*"
22	002	BLDG DEPT	2063	FRONT ST	A-18-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 2063 FRONT ST.PDF	Open			ENTER NAME
23	002	BLDG DEPT	1916	HIGHBRIDGE RD	A-16-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 1916 HIGHBRIDGE RD.PDF	Open
24	002	BLDG DEPT	1787	STATE RD	A-20-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 1787 STATE RD.PDF	Open
25	002	BLDG DEPT	1752	WILLIAMS ST	A-15-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 1752 WILLIAMS ST.PDF	Open
26	002	BLDG DEPT	1225	MONROE FALLS AVE	C-6705		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT 1225 MONROE FALLS AVE.PDF	Open
27	002	BLDG DEPT		STATE RD AND CHESTNUT BLVD	A-14-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT STATE RD AND CHESTNUT BLVD.PDF	Open			SEARCH RESULTS BY ADDRESS
28	002	BLDG DEPT		FRATERNAL ORDER OF EAGLES	A-22-R		\\CF-FILE04\Engineering\ScanWorks\002 BLDG DEPT FRATERNAL ORDER OF EAGLES.PDF	Open
29	003	BLDG DEPT	800	TALLMADGE RD	A-29-R	A	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT 800 TALLMADGE RD A.PDF	Open			BOX NO.	SEARCH RESULTS FOR			RETURN CONVERTED TO TEXT	FILTER RETURN
30	003	BLDG DEPT	800	TALLMADGE RD	A-29-R	B	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT 800 TALLMADGE RD B.PDF	Open							0	0
31	003	BLDG DEPT	3131	W BAILEY RD	A-28-R		\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT 3131 W BAILEY RD.PDF	Open
32	003	BLDG DEPT	2300	4TH ST	A-27-R		\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT 2300 4TH ST.PDF	Open
33	003	BLDG DEPT	1910	SEARL ST	A-26-R		\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT 1910 SEARL ST.PDF	Open
34	003	BLDG DEPT		YMCA		A	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT YMCA A.PDF	Open
35	003	BLDG DEPT		NEWBERRY SCHOOL	1635-b	A	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT NEWBERRY SCHOOL A.PDF	Open
36	003	BLDG DEPT		ELIZABETH PRICE SCHOOL	2297	A	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT ELIZABETH PRICE SCHOOL A.PDF	Open
37	003	BLDG DEPT		CRAWFORD SCHOOL	4453	A	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT CRAWFORD SCHOOL A.PDF	Open
38	003	BLDG DEPT		YMCA	65	B	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT YMCA B.PDF	Open
39	003	BLDG DEPT		NEWBERRY SCHOOL	129	B	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT NEWBERRY SCHOOL B.PDF	Open
40	003	BLDG DEPT		ELIZABETH PRICE SCHOOL		B	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT ELIZABETH PRICE SCHOOL B.PDF	Open
41
42	003	BLDG DEPT		NEWBERRY SCHOOL		C	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT NEWBERRY SCHOOL C.PDF	Open
43	003	BLDG DEPT		ELIZABETH PRICE SCHOOL		C	\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT ELIZABETH PRICE SCHOOL C.PDF	Open
44	003	BLDG DEPT		SILL SCHOOL PLUMBING			\\CF-FILE04\Engineering\ScanWorks\003 BLDG DEPT SILL SCHOOL PLUMBING.PDF	Open
45	004	BLDG DEPT	355	PORTAGE TRL	A-33-R		\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT 355 PORTAGE TRL.PDF	Open
46	004	BLDG DEPT	2916	OAKWOOD DR	A-39-R		\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT 2916 OAKWOOD DR.PDF	Open
47	004	BLDG DEPT	2834	2ND ST	A-35-R		\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT 2834 2ND ST.PDF	Open
48	004	BLDG DEPT	2735	FRONT ST	A-38-R	A	\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT 2735 FRONT ST A.PDF	Open
49	004	BLDG DEPT	2735	FRONT ST	A-38-R	B	\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT 2735 FRONT ST B.PDF	Open
50	004	BLDG DEPT	2421	STATE RD	A-37-R		\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT 2421 STATE RD.PDF	Open
51	004	BLDG DEPT	1850	STATE RD	A-36-R	A	\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT 1850 STATE RD A.PDF	Open
52	004	BLDG DEPT	1850	STATE RD	A-36-R	B	\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT 1850 STATE RD B.PDF	Open
53	004	BLDG DEPT	1850	STATE RD	A-36-R	C	\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT 1850 STATE RD C.PDF	Open
54	004	BLDG DEPT	1850	STATE RD	A-36-R	D	\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT 1850 STATE RD D.PDF	Open
55	004	BLDG DEPT		STATE RD AND CHAMBERLIN	A-41-R	A	\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT STATE RD AND CHAMBERLIN A.PDF	Open			SEARCH RESULTS BY PLAN NO.
56	004	BLDG DEPT		STATE RD AND CHAMBERLIN	A-41-R	B	\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT STATE RD AND CHAMBERLIN B.PDF	Open
57	004	BLDG DEPT		STATE RD AND FALLS ST			\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT STATE RD AND FALLS ST.PDF	Open			BOX NO.	SEARCH RESULTS FOR
58	004	BLDG DEPT		FRATERNAL ORDER OF EAGLES	A-34-R		\\CF-FILE04\Engineering\ScanWorks\004 BLDG DEPT FRATERNAL ORDER OF EAGLES.PDF	Open				65
59	005	BLDG DEPT	807	WASHINGTON	A-75		\\CF-FILE04\Engineering\ScanWorks\005 BLDG DEPT 807 WASHINGTON.PDF	Open							RETURN CONVERTED TO TEXT	FILTER RETURN
60	005	BLDG DEPT	739	PORTAGE TRL			\\CF-FILE04\Engineering\ScanWorks\005 BLDG DEPT 739 PORTAGE TRL.PDF	Open			#VALUE!	#VALUE!			#VALUE!	#VALUE!
61	005	BLDG DEPT	739	ROOSEVELT	A-55		\\CF-FILE04\Engineering\ScanWorks\005 BLDG DEPT 739 ROOSEVELT.PDF	Open
62	005	BLDG DEPT	735	LEAVITT	A-71		\\CF-FILE04\Engineering\ScanWorks\005 BLDG DEPT 735 LEAVITT.PDF	Open
CCFTABLE

Cell Formulas
Range	Formula
N2:N3,N8:N9,N18:N19,N29:N30,N48:N49,N51:N54	N2	=HYPERLINK(CONCATENATE($W$1&H2&I2& J2&" "&K2&" "&M2&".PDF"))
O2:O40,O42:O62	O2	=HYPERLINK(N2,"Open")
N4:N7,N10:N13,N17,N20:N26,N31:N33,N45:N47,N50,N59:N62	N4	=HYPERLINK(CONCATENATE($W$1&H4&I4& J4&" "&K4&M4&".PDF"))
N14	N14	=HYPERLINK(CONCATENATE($W$1&H14&I14&J14&" "&K14&M14&".PDF"))
N15:N16,N34:N40,N42:N43,N55:N56	N15	=HYPERLINK(CONCATENATE($W$1&H15&I15& J15&K15&" "&M15&".PDF"))
N27:N28,N44,N57:N58	N27	=HYPERLINK(CONCATENATE($W$1&H27&I27&K27&".PDF"))
R3	R3	=SHEETS()-2
U10	U10	=INDEX(N:N,MATCH(1,(R10=J:J)*(S10=K:K),0),1)
V18	V18	=VLOOKUP($R$18,$L$2:$N$6895,3,FALSE)
R19	R19	=IF(R18="","",HYPERLINK(V18,"OPEN"))
U23	U23	=IF(R23="","",VLOOKUP(R23&"*",K2:N6895,4,FALSE))
R24	R24	=IF(R23="","",HYPERLINK(U23,"OPEN"))
R30	R30	=IF(S10="","",FILTER(FILTER($H$2:$N$6895,($K$2:$K$6895=$S$10)*($J$2:$J$6895=$R$10),"NOTHING FOUND"),{1,0,0,0,0,0,0}))
W30	W30	=FILTER(FILTER($H$2:$N$6895,($K$2:$K$6895=$S$10)*($J$2:$J$6895=$R$10),"NOTHING FOUND"),{0,0,0,0,0,0,1})
S30	S30	=IF(S10="","",(HYPERLINK(V30,"OPEN")))
S31:S40,S60:S62,S42:S54	S31	=IF(V31="","",(HYPERLINK(V31,"OPEN")))
V30:V40,V60:V62,V42:V58	V30	=IF(W30="","",ARRAYTOTEXT(W30))
S58	S58	=IF(R18="","",R18)
R60	R60	=IF(R18="","",FILTER(FILTER($H$2:$N$6895,($L$2:$L$6895=$R$18),"NOTHING FOUND"),{1,0,0,0,0,0,0}))
W60	W60	=IF(R18="","",FILTER(FILTER($H$2:$N$6895,($L$2:$L$6895=$R$18),"NOTHING FOUND"),{0,0,0,0,0,0,1}))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H2:O2	Expression	=MOD(ROW(),2)=1	text	NO
H2:O2	Expression	=MOD(ROW(),2)=1	text	NO
H2:P2	Expression	=MOD(ROW(),2)=1	text	NO
H3:O3	Expression	=MOD(ROW(),2)=1	text	NO
H3:O3	Expression	=MOD(ROW(),2)=1	text	NO
H3:P3	Expression	=MOD(ROW(),2)=1	text	NO
H4:O1900,H1901:K2361,M1901:O2361,H2362:O5465,H5286:H5551	Expression	=MOD(ROW(),2)=1	text	NO
H4:O1900,H1901:K2361,M1901:O2361,H2362:O5465,H5286:H5551	Expression	=MOD(ROW(),2)=1	text	NO
H4:P1900,H5908:O5908,H5924:O5924,H5958:O5958,H5870:O5870,H5872:O5872,H5874:O5874,H5876:O5876,H5878:O5878,H5880:O5880,H5882:O5882,H5884:O5884,H5886:O5886,H5888:O5888,H5890:O5890,H5892:O5892,H5894:O5894,H5896:O5896,H5898:O5898,H5900:O5900,H5902:O5902	Expression	=MOD(ROW(),2)=1	text	NO

 

[Fluff]

Thanks for that, how about

=IF(R18="","",FILTER(N2:N109,L2:L109=IFERROR(--R18,R18),"NOTHING FOUND"))

 

[angleright]

Should i put that in w60?

 

[Fluff]

If that's where you want the result, then yes.