Find alpha numeric text string within a list and return value from another column

[Bravo661]

I've done a search and can't quite find what I'm looking for.

I have a list of construction document file names.
I have a seperate list lof partial file names with associated descriptions.
I want to find the partial file name within the list and return the associated description.

 

[awoohaw]

Your xl2bb minisheet did not paste the entire range. When using that tool, you need to select the range to copy first, then click the icon (please select all the options that are available so the forum gets all the information possible). Then come to the posting window and CNTL-V to paste.

 

[Bravo661]

I've done a search and can't quite find what I'm looking for.

I have a list of construction document file names.
I have a seperate list lof partial file names with associated descriptions.
I want to find the partial file name within the list and return the associated description.

Mini sheet corrected

Just to recap.

Column A full file name
Column B is the result of looking for full text string within column C in column A and returning the result from Column D

File Decription link.xlsx
	A	B	C	D
1	DOCUMENT LIST	Result required	PARTIAL DOCUMENT NAME	DESCRIPTION TO ASSOCIATE WITH DOCUMENT LIST NAME
2	1. 5718-WAL-ZZ-00-DR-S-1100-T02.dwg	LEVEL 00 GENERAL ARRANGEMENT	5718-WAL-ZZ-00-DR-S-1100	LEVEL 00 GENERAL ARRANGEMENT
3	10. 5718-WAL-ZZ-02-DR-S-1100-T01.pdf	LEVEL 00 GENERAL ARRANGEMENT	5718-WAL-ZZ-00-DR-S-1400	LOADING PLAN LEVEL 00
4	100. 5718-WAL-ZZ-ZZ-DR-S-2115-T01.pdf	CORE 4 WALL ELEVATIONS SHEET 1	5718-WAL-ZZ-01-DR-S-1100	LEVEL 01 GENERAL ARRANGEMENT
5	101. 5718-WAL-ZZ-ZZ-DR-S-2116-T01.dwg	CORE 4 WALL ELEVATIONS SHEET 2	5718-WAL-ZZ-01-DR-S-1400	LOADING PLAN LEVEL 01
6	102. 5718-WAL-ZZ-ZZ-DR-S-2116-T01.pdf	CORE 4 WALL ELEVATIONS SHEET 2	5718-WAL-ZZ-02-DR-S-1100	LEVEL 02 GENERAL ARRANGEMENT
7	103. 5718-WAL-ZZ-ZZ-DR-S-2120-T01.dwg	CORE 5 WALL ELEVATIONS	5718-WAL-ZZ-02-DR-S-1400	LOADING PLAN LEVEL 02
8	104. 5718-WAL-ZZ-ZZ-DR-S-2120-T01.pdf	CORE 5 WALL ELEVATIONS	5718-WAL-ZZ-03-DR-S-1100	LEVEL 03 GENERAL ARRANGEMENT
9	105. 5718-WAL-ZZ-ZZ-DR-S-2125-T01.dwg	CORE 6 WALL ELEVATIONS	5718-WAL-ZZ-03-DR-S-1400	LOADING PLAN LEVEL 03
10	106. 5718-WAL-ZZ-ZZ-DR-S-2125-T01.pdf	CORE 6 WALL ELEVATIONS	5718-WAL-ZZ-04-DR-S-1100	LEVEL 04 GENERAL ARRANGEMENT
11	107. 5718-WAL-ZZ-ZZ-DR-S-2130-T01.dwg	CORE 7 WALL ELEVATIONS	5718-WAL-ZZ-03-DR-S-1400	LOADING PLAN LEVEL 04
12	108. 5718-WAL-ZZ-ZZ-DR-S-2130-T01.pdf	LEVEL 00 GENERAL ARRANGEMENT	5718-WAL-ZZ-05-DR-S-1100	LEVEL 05 GENERAL ARRANGEMENT
13	109. 5718-WAL-ZZ-ZZ-DR-S-2135-T01.dwg		5718-WAL-ZZ-05-DR-S-1400	LOADING PLAN LEVEL 05
14	11. 5718-WAL-ZZ-02-DR-S-1400-T01.pdf		5718-WAL-ZZ-06-DR-S-1100	LEVEL 06 GENERAL ARRANGEMENT
15	110. 5718-WAL-ZZ-ZZ-DR-S-2135-T01.pdf		5718-WAL-ZZ-06-DR-S-1400	LOADING PLAN LEVEL 06
16	111. 5718-WAL-ZZ-ZZ-DR-S-2140-T01.dwg		5718-WAL-ZZ-07-DR-S-1100	LEVEL 07 GENERAL ARRANGEMENT
17	112. 5718-WAL-ZZ-ZZ-DR-S-2140-T01.pdf		5718-WAL-ZZ-07-DR-S-1400	LOADING PLAN LEVEL 07
18	113. 5718-WAL-ZZ-ZZ-DR-S-2141-T01.dwg		5718-WAL-ZZ-08-DR-S-1100	LEVEL 08 GENERAL ARRANGEMENT
19	114. 5718-WAL-ZZ-ZZ-DR-S-2141-T01.pdf		5718-WAL-ZZ-08-DR-S-1400	LOADING PLAN LEVEL 08
20	115. 5718-WAL-ZZ-ZZ-DR-S-2200-T01.dwg		5718-WAL-ZZ-09-DR-S-1100	LEVEL 09 GENERAL ARRANGEMENT
21	116. 5718-WAL-ZZ-ZZ-DR-S-2200-T01.pdf		5718-WAL-ZZ-09-DR-S-1400	LOADING PLAN LEVEL 09
22	117. 5718-WAL-ZZ-ZZ-DR-S-2210-T01.dwg		5718-WAL-ZZ-10-DR-S-1100	LEVEL 10 GENERAL ARRANGEMENT
23	118. 5718-WAL-ZZ-ZZ-DR-S-2210-T01.pdf		5718-WAL-ZZ-10-DR-S-1400	LOADING LEVEL
24	119. 5718-WAL-ZZ-ZZ-DR-S-2900-T01.dwg		5718-WAL-ZZ-FN-DR-S-1000	FOUNDATION LEVEL GENERAL ARRANGEMENT
25	12. 5718-WAL-ZZ-02-DR-S-1400_T01.dwg		5718-WAL-ZZ-PL-DR-S-1000	PILING GENERAL ARRANGEMENT
26	120. 5718-WAL-ZZ-ZZ-DR-S-2900-T01.pdf		5718-WAL-ZZ-RF-DR-S-1100	ROOF LEVEL GENERAL ARRANGEMENT
27	121. 5718-WAL-ZZ-ZZ-DR-S-7100_P01.dwg		5718-WAL-ZZ-RF-DR-S-1400	LOADING PLAN ROOF LEVEL
28	122. 5718-WAL-ZZ-ZZ-DR-S-7100_P01.pdf		5718-WAL-ZZ-XX-DR-S-0004	REINFORCEMENT ESTIMATES
29	13. 5718-WAL-ZZ-03-DR-S-1100-T01.dwg		5718-WAL-ZZ-XX-DR-S-0008	WATERPROOFING PRINCIPLES DRAWING
30	14. 5718-WAL-ZZ-03-DR-S-1100-T01.pdf		5718-WAL-ZZ-ZZ-DR-S-1110	CORE 1 G.A
31	15. 5718-WAL-ZZ-03-DR-S-1400-T01.pdf		5718-WAL-ZZ-ZZ-DR-S-1115	CORE 2 G.A
32	16. 5718-WAL-ZZ-03-DR-S-1400_T01.dwg		5718-WAL-ZZ-ZZ-DR-S-1120	CORE 3 G.A
33	17. 5718-WAL-ZZ-04-DR-S-1100-T01.dwg		5718-WAL-ZZ-ZZ-DR-S-1125	CORE 4 G.A
34	18. 5718-WAL-ZZ-04-DR-S-1100-T01.pdf		5718-WAL-ZZ-ZZ-DR-S-1130	CORE 5 G.A
35	19. 5718-WAL-ZZ-04-DR-S-1400-T01.pdf		5718-WAL-ZZ-ZZ-DR-S-1135	CORE 6 G.A
36	2. 5718-WAL-ZZ-00-DR-S-1100-T02.pdf		I 5718-WAL-ZZ-ZZ-DR-S-1140	CORE 7 G.A
37	20. 5718-WAL-ZZ-04-DR-S-1400_T01.dwg		5718-WAL-ZZ-ZZ-DR-S-1145	CORE 8 G.A
38	21. 5718-WAL-ZZ-05-DR-S-1100-T01.dwg		5718-WAL-ZZ-ZZ-DR-S-1150	CORE 9 G.A
39	22. 5718-WAL-ZZ-05-DR-S-1100-T01.pdf		5718-WAL-ZZ-ZZ-DR-S-1170	SUBSTATION GENERAL ARRANGEMENT
40	23. 5718-WAL-ZZ-05-DR-S-1400-T01.pdf		5718-WAL-ZZ-ZZ-DR-S-2001	BUILDING SECTIONS SHEET 1
41	24. 5718-WAL-ZZ-05-DR-S-1400_T01.dwg		5718-WAL-ZZ-ZZ-DR-S-2002	BUILDING SECTIONS SHEET 2
42	25. 5718-WAL-ZZ-06-DR-S-1100-T01.dwg		5718-WAL-ZZ-ZZ-DR-S-2003	BUILDING SECTIONS SHEET 3
43	26. 5718-WAL-ZZ-06-DR-S-1100-T01.pdf		5718-WAL-ZZ-ZZ-DR-S-2004	BUILDING SECTIONS SHEET 4
44	27. 5718-WAL-ZZ-06-DR-S-1400-T01.pdf		5718-WAL-ZZ-ZZ-DR-S-2005	BUILDING SECTIONS SHEET 5
45	28. 5718-WAL-ZZ-06-DR-S-1400_T01.dwg		5718-WAL-ZZ-ZZ-DR-S-2006	BUILDING SECTIONS SHEET 6
46	29. 5718-WAL-ZZ-07-DR-S-1100-T01.dwg		5718-WAL-ZZ-ZZ-DR-S-2007	BUILDING SECTIONS SHEET 7
47	3. 5718-WAL-ZZ-00-DR-S-1400-T01.pdf		5718-WAL-ZZ-ZZ-DR-S-2010	SUBSTRUCTURE DETAIL SECTIONS
48	30. 5718-WAL-ZZ-07-DR-S-1100-T01.pdf		5718-WAL-ZZ-ZZ-DR-S-2100	CORE 1 WALL ELEVATIONS
49	31. 5718-WAL-ZZ-07-DR-S-1400-T01.pdf		5718-WAL-ZZ-ZZ-DR-S-2105	CORE 2 WALL ELEVATIONS
50	32. 5718-WAL-ZZ-07-DR-S-1400_T01.dwg		5718-WAL-ZZ-ZZ-DR-S-2110	CORE 3 WALL ELEVATIONS
51	33. 5718-WAL-ZZ-08-DR-S-1100-T01.dwg		5718-WAL-ZZ-ZZ-DR-S-2115	CORE 4 WALL ELEVATIONS SHEET 1
52	34. 5718-WAL-ZZ-08-DR-S-1100-T01.pdf		5718-WAL-ZZ-ZZ-DR-S-2116	CORE 4 WALL ELEVATIONS SHEET 2
Sheet2

 

[Sanjeev1976]

You can try :

Book22
	A	B	C	D
1	DOCUMENT LIST	Result required	PARTIAL DOCUMENT NAME	DESCRIPTION TO ASSOCIATE WITH DOCUMENT LIST NAME
2	1. 5718-WAL-ZZ-00-DR-S-1100-T02.dwg	LEVEL 00 GENERAL ARRANGEMENT	5718-WAL-ZZ-00-DR-S-1100	LEVEL 00 GENERAL ARRANGEMENT
3	10. 5718-WAL-ZZ-02-DR-S-1100-T01.pdf	LEVEL 02 GENERAL ARRANGEMENT	5718-WAL-ZZ-00-DR-S-1400	LOADING PLAN LEVEL 00
4	100. 5718-WAL-ZZ-ZZ-DR-S-2115-T01.pdf	CORE 4 WALL ELEVATIONS SHEET 1	5718-WAL-ZZ-01-DR-S-1100	LEVEL 01 GENERAL ARRANGEMENT
5	101. 5718-WAL-ZZ-ZZ-DR-S-2116-T01.dwg	CORE 4 WALL ELEVATIONS SHEET 2	5718-WAL-ZZ-01-DR-S-1400	LOADING PLAN LEVEL 01
6	102. 5718-WAL-ZZ-ZZ-DR-S-2116-T01.pdf	CORE 4 WALL ELEVATIONS SHEET 2	5718-WAL-ZZ-02-DR-S-1100	LEVEL 02 GENERAL ARRANGEMENT
7	103. 5718-WAL-ZZ-ZZ-DR-S-2120-T01.dwg		5718-WAL-ZZ-02-DR-S-1400	LOADING PLAN LEVEL 02
8	104. 5718-WAL-ZZ-ZZ-DR-S-2120-T01.pdf		5718-WAL-ZZ-03-DR-S-1100	LEVEL 03 GENERAL ARRANGEMENT
9	105. 5718-WAL-ZZ-ZZ-DR-S-2125-T01.dwg		5718-WAL-ZZ-03-DR-S-1400	LOADING PLAN LEVEL 03
10	106. 5718-WAL-ZZ-ZZ-DR-S-2125-T01.pdf		5718-WAL-ZZ-04-DR-S-1100	LEVEL 04 GENERAL ARRANGEMENT
11	107. 5718-WAL-ZZ-ZZ-DR-S-2130-T01.dwg		5718-WAL-ZZ-03-DR-S-1400	LOADING PLAN LEVEL 04
12	108. 5718-WAL-ZZ-ZZ-DR-S-2130-T01.pdf		5718-WAL-ZZ-05-DR-S-1100	LEVEL 05 GENERAL ARRANGEMENT
13	109. 5718-WAL-ZZ-ZZ-DR-S-2135-T01.dwg		5718-WAL-ZZ-05-DR-S-1400	LOADING PLAN LEVEL 05
14	11. 5718-WAL-ZZ-02-DR-S-1400-T01.pdf	LOADING PLAN LEVEL 02	5718-WAL-ZZ-06-DR-S-1100	LEVEL 06 GENERAL ARRANGEMENT
15	110. 5718-WAL-ZZ-ZZ-DR-S-2135-T01.pdf		5718-WAL-ZZ-06-DR-S-1400	LOADING PLAN LEVEL 06
16	111. 5718-WAL-ZZ-ZZ-DR-S-2140-T01.dwg		5718-WAL-ZZ-07-DR-S-1100	LEVEL 07 GENERAL ARRANGEMENT
17	112. 5718-WAL-ZZ-ZZ-DR-S-2140-T01.pdf		5718-WAL-ZZ-07-DR-S-1400	LOADING PLAN LEVEL 07
18	113. 5718-WAL-ZZ-ZZ-DR-S-2141-T01.dwg		5718-WAL-ZZ-08-DR-S-1100	LEVEL 08 GENERAL ARRANGEMENT
19	114. 5718-WAL-ZZ-ZZ-DR-S-2141-T01.pdf		5718-WAL-ZZ-08-DR-S-1400	LOADING PLAN LEVEL 08
20	115. 5718-WAL-ZZ-ZZ-DR-S-2200-T01.dwg		5718-WAL-ZZ-09-DR-S-1100	LEVEL 09 GENERAL ARRANGEMENT
21	116. 5718-WAL-ZZ-ZZ-DR-S-2200-T01.pdf		5718-WAL-ZZ-09-DR-S-1400	LOADING PLAN LEVEL 09
22	117. 5718-WAL-ZZ-ZZ-DR-S-2210-T01.dwg		5718-WAL-ZZ-10-DR-S-1100	LEVEL 10 GENERAL ARRANGEMENT
23	118. 5718-WAL-ZZ-ZZ-DR-S-2210-T01.pdf		5718-WAL-ZZ-10-DR-S-1400	LOADING LEVEL
24	119. 5718-WAL-ZZ-ZZ-DR-S-2900-T01.dwg		5718-WAL-ZZ-FN-DR-S-1000	FOUNDATION LEVEL GENERAL ARRANGEMENT
25	12. 5718-WAL-ZZ-02-DR-S-1400_T01.dwg	LOADING PLAN LEVEL 02	5718-WAL-ZZ-PL-DR-S-1000	PILING GENERAL ARRANGEMENT
26	120. 5718-WAL-ZZ-ZZ-DR-S-2900-T01.pdf		5718-WAL-ZZ-RF-DR-S-1100	ROOF LEVEL GENERAL ARRANGEMENT
27	121. 5718-WAL-ZZ-ZZ-DR-S-7100_P01.dwg		5718-WAL-ZZ-RF-DR-S-1400	LOADING PLAN ROOF LEVEL
28	122. 5718-WAL-ZZ-ZZ-DR-S-7100_P01.pdf		5718-WAL-ZZ-XX-DR-S-0004	REINFORCEMENT ESTIMATES
29	13. 5718-WAL-ZZ-03-DR-S-1100-T01.dwg	LEVEL 03 GENERAL ARRANGEMENT	5718-WAL-ZZ-XX-DR-S-0008	WATERPROOFING PRINCIPLES DRAWING
30	14. 5718-WAL-ZZ-03-DR-S-1100-T01.pdf	LEVEL 03 GENERAL ARRANGEMENT	5718-WAL-ZZ-ZZ-DR-S-1110	CORE 1 G.A
31	15. 5718-WAL-ZZ-03-DR-S-1400-T01.pdf	LOADING PLAN LEVEL 03	5718-WAL-ZZ-ZZ-DR-S-1115	CORE 2 G.A
32	16. 5718-WAL-ZZ-03-DR-S-1400_T01.dwg	LOADING PLAN LEVEL 03	5718-WAL-ZZ-ZZ-DR-S-1120	CORE 3 G.A
33	17. 5718-WAL-ZZ-04-DR-S-1100-T01.dwg	LEVEL 04 GENERAL ARRANGEMENT	5718-WAL-ZZ-ZZ-DR-S-1125	CORE 4 G.A
34	18. 5718-WAL-ZZ-04-DR-S-1100-T01.pdf	LEVEL 04 GENERAL ARRANGEMENT	5718-WAL-ZZ-ZZ-DR-S-1130	CORE 5 G.A
35	19. 5718-WAL-ZZ-04-DR-S-1400-T01.pdf		5718-WAL-ZZ-ZZ-DR-S-1135	CORE 6 G.A
36	2. 5718-WAL-ZZ-00-DR-S-1100-T02.pdf	LEVEL 00 GENERAL ARRANGEMENT	I 5718-WAL-ZZ-ZZ-DR-S-1140	CORE 7 G.A
37	20. 5718-WAL-ZZ-04-DR-S-1400_T01.dwg		5718-WAL-ZZ-ZZ-DR-S-1145	CORE 8 G.A
38	21. 5718-WAL-ZZ-05-DR-S-1100-T01.dwg	LEVEL 05 GENERAL ARRANGEMENT	5718-WAL-ZZ-ZZ-DR-S-1150	CORE 9 G.A
39	22. 5718-WAL-ZZ-05-DR-S-1100-T01.pdf	LEVEL 05 GENERAL ARRANGEMENT	5718-WAL-ZZ-ZZ-DR-S-1170	SUBSTATION GENERAL ARRANGEMENT
40	23. 5718-WAL-ZZ-05-DR-S-1400-T01.pdf	LOADING PLAN LEVEL 05	5718-WAL-ZZ-ZZ-DR-S-2001	BUILDING SECTIONS SHEET 1
41	24. 5718-WAL-ZZ-05-DR-S-1400_T01.dwg	LOADING PLAN LEVEL 05	5718-WAL-ZZ-ZZ-DR-S-2002	BUILDING SECTIONS SHEET 2
42	25. 5718-WAL-ZZ-06-DR-S-1100-T01.dwg	LEVEL 06 GENERAL ARRANGEMENT	5718-WAL-ZZ-ZZ-DR-S-2003	BUILDING SECTIONS SHEET 3
43	26. 5718-WAL-ZZ-06-DR-S-1100-T01.pdf	LEVEL 06 GENERAL ARRANGEMENT	5718-WAL-ZZ-ZZ-DR-S-2004	BUILDING SECTIONS SHEET 4
44	27. 5718-WAL-ZZ-06-DR-S-1400-T01.pdf	LOADING PLAN LEVEL 06	5718-WAL-ZZ-ZZ-DR-S-2005	BUILDING SECTIONS SHEET 5
45	28. 5718-WAL-ZZ-06-DR-S-1400_T01.dwg	LOADING PLAN LEVEL 06	5718-WAL-ZZ-ZZ-DR-S-2006	BUILDING SECTIONS SHEET 6
46	29. 5718-WAL-ZZ-07-DR-S-1100-T01.dwg	LEVEL 07 GENERAL ARRANGEMENT	5718-WAL-ZZ-ZZ-DR-S-2007	BUILDING SECTIONS SHEET 7
47	3. 5718-WAL-ZZ-00-DR-S-1400-T01.pdf	LOADING PLAN LEVEL 00	5718-WAL-ZZ-ZZ-DR-S-2010	SUBSTRUCTURE DETAIL SECTIONS
48	30. 5718-WAL-ZZ-07-DR-S-1100-T01.pdf	LEVEL 07 GENERAL ARRANGEMENT	5718-WAL-ZZ-ZZ-DR-S-2100	CORE 1 WALL ELEVATIONS
49	31. 5718-WAL-ZZ-07-DR-S-1400-T01.pdf	LOADING PLAN LEVEL 07	5718-WAL-ZZ-ZZ-DR-S-2105	CORE 2 WALL ELEVATIONS
50	32. 5718-WAL-ZZ-07-DR-S-1400_T01.dwg	LOADING PLAN LEVEL 07	5718-WAL-ZZ-ZZ-DR-S-2110	CORE 3 WALL ELEVATIONS
51	33. 5718-WAL-ZZ-08-DR-S-1100-T01.dwg	LEVEL 08 GENERAL ARRANGEMENT	5718-WAL-ZZ-ZZ-DR-S-2115	CORE 4 WALL ELEVATIONS SHEET 1
52	34. 5718-WAL-ZZ-08-DR-S-1100-T01.pdf	LEVEL 08 GENERAL ARRANGEMENT	5718-WAL-ZZ-ZZ-DR-S-2116	CORE 4 WALL ELEVATIONS SHEET 2
Sheet2

Cell Formulas
Range	Formula
B2:B52	B2	=XLOOKUP(LEFT(MID(A2,FIND(". ",A2)+2,LEN(A2)-FIND(". ",A2)+2),SEARCH("???.",MID(A2,FIND(". ",A2)+2,LEN(A2)-FIND(". ",A2)+2))-2),$C$2:$C$52,$D$2:$D$52,"")

 

[Bravo661]

Sanjieev, Many thanks, works perfectly. Regards,

 

[Bravo661]

Whilst this worked on the previous batch, unfortunately, on this batch some reason it's not working. Am I missing something?
I note that it is looking for ". ". In many cases the "." will not be present.

Architectural files res.xlsx
	A	B	C	D
1	DOCUMENT LIST	Match result	PARTIAL DOCUMENT NAME	DESCRIPTION TO ASSOCIATE WITH DOCUMENT LIST NAME
2	1. A348-MCO-XX-ZZ-DR-A-01201.dwg		A348-MCO-XX-00-DR-A-01100	GA PLAN LEVEL 00 & MEZZANINE
3	2. A348-MCO-XX-ZZ-DR-A-01201.pdf		A348-MCO-XX-01-DR-A-01101	GA PLAN LEVEL 01
4	3. A348-MCO-XX-ZZ-DR-A-01202.dwg		A348-MCO-XX-02-DR-A-01102	GA PLAN LEVEL 02
5	4. A348-MCO-XX-ZZ-DR-A-01202.pdf		A348-MCO-XX-03-DR-A-01103	GA PLAN LEVEL 03
6	5. A348-MCO-XX-ZZ-DR-A-01203.dwg		A348-MCO-XX-04-DR-A-01104	GA PLAN LEVEL 04
7	6. A348-MCO-XX-ZZ-DR-A-01203.pdf		A348-MCO-XX-05-DR-A-01105	GA PLAN LEVEL 05
8	7. A348-MCO-XX-ZZ-DR-A-01204.dwg		A348-MCO-XX-06-DR-A-01106	GA PLAN LEVEL 06
9	8. A348-MCO-XX-ZZ-DR-A-01204.pdf		A348-MCO-XX-07-DR-A-01107	GA PLAN LEVEL 07
10	9. A348-MCO-XX-ZZ-DR-A-01205.dwg		A348-MCO-XX-08-DR-A-01108	GA PLAN LEVEL 08
11	10. A348-MCO-XX-ZZ-DR-A-01205.pdf		A348-MCO-XX-09-DR-A-01109	GA PLAN LEVEL 09
12	11. A348-MCO-XX-ZZ-DR-A-01206.dwg		A348-MCO-XX-10-DR-A-01110	GA PLAN LEVEL 10
13	12. A348-MCO-XX-ZZ-DR-A-01206.pdf		A348-MCO-XX-R1-DR-A-01120	GA PLAN ROOF LEVEL
14	13. A348-MCO-XX-00-DR-A-01100.dwg		A348-MCO-XX-ZZ-DR-A-01201	GA NORTH ELEVATION
15	14. A348-MCO-XX-00-DR-A-01100.pdf		A348-MCO-XX-ZZ-DR-A-01202	GA EAST (EAST WING) ELEVATION
16	15. A348-MCO-XX-01-DR-A-01101.dwg		A348-MC0-XX-ZZ-DR-A-01203	GA EAST (WEST WING) ELEVATION
17	16. A348-MCO-XX-01-DR-A-01101.pdf		A348-MCO-XX-ZZ-DR-A-01204	GA SOUTH ELEVATION
18	17. A348-MCO-XX-02-DR-A-01102.dwg		A348-MCO-XX-ZZ-DR-A-01205	GA WEST (EAST WING) ELEVATION
19	18. A348-MCO-XX-02-DR-A-01102.pdf		A348-MCO-XX-ZZ-DR-A-01206	GA WEST (WEST WING) ELEVATION
20	19. A348-MCO-XX-03-DR-A-01103.dwg		A348-MCO-XX-ZZ-DR-A-01301	GA SECTION AA
21	20. A348-MCO-XX-03-DR-A-01103.pdf		A348-MCO-XX-ZZ-DR-A-01302	GA SECTION BB
22	21. A348-MCO-XX-05-DR-A-01105.dwg		A348-MCO-XX-ZZ-DR-A-01303	GA SECTION CC
23	22. A348-MCO-XX-05-DR-A-01105.pdf		A348-MCO-XX-ZZ-DR-A-01304	GA SECTION DD
24	23. A348-MCO-XX-06-DR-A-01106.dwg		A348-MCO-XX-ZZ-DR-A-01401	STUDENT RESIDENTIAL TYPES 01
25	24. A348-MCO-XX-06-DR-A-01106.pdf		A348-MCO-XX-ZZ-DR-A-01402	STUDENT RESIDENTIAL TYPES 02
26	25. A348-MCO-XX-07-DR-A-01107.dwg		A348-MCO-XX-ZZ-DR-A-01411	RESIDENTIAL TYPES
27	26. A348-MCO-XX-07-DR-A-01107.pdf		A348-MCO-XX-ZZ-DR-A-01450	STUDENT AND COMMERCIAL REFUSE
28	27. A348-MCO-XX-08-DR-A-01108.dwg		A348-MCO-XX-ZZ-DR-A-01452	OFFICE CYCLE STORE, RESIDENTIAL CYCLE STORE & LL
29	28. A348-MCO-XX-08-DR-A-01108.pdf		A348-MCO-XX-XX-DR-A-01460	VISUALS - STUDENT ROOM TYPES
30	29. A348-MCO-XX-09-DR-A-01109.dwg		A348-MCO-XX-XX-DR-A-01461	VISUALS - STUDENT ROOM TYPES
31	30. A348-MCO-XX-09-DR-A-01109.pdf		A348-MCO-XX-XX-DR-A-01462	VISUALS - KEY WORKER UNIT & PAVILIONS
32	31. A348-MCO-XX-10-DR-A-01110.dwg		A348-MCO-XX-XX-DR-A-01463	VISUALS - WORKSPACE
33	32. A348-MCO-XX-10-DR-A-01110.pdf		A348-MCO-XX-00-DR-A-21100	SCOPING THERMAL PLANS - LEVEL 00
34	33. A348-MCO-XX-R1-DR-A-01111.dwg		A348-MCO-XX-01-DR-A-21101	SCOPING THERMAL PLANS - LEVEL 01
35	34. A348-MCO-XX-R1-DR-A-01111.pdf		A348-MCO-XX-02-DR-A-21102	SCOPING THERMAL PLANS - LEVEL 02
36	35. A348-MCO-XX-XX-DR-A-01460.pdf		A348-MCO-XX-03-DR-A-21103	SCOPING THERMAL PLANS - LEVEL 03 & 04
37	36. A348-MCO-XX-XX-DR-A-01461.pdf		A348-MCO-XX-05-DR-A-S105	SCOPING THERMAL PLANS - LEVEL 05
38	37. A348-MCO-XX-XX-DR-A-01462.pdf		A348-MCO-XX-06-DR-A-21106	SCOPING THERMAL PLANS - LEVEL 06
39	38. A348-MCO-XX-XX-DR-A-01463.pdf		A348-MCO-XX-07-DR-A-21107	SCOPING THERMAL PLANS - LEVEL 07
40	39. A348-MCO-XX-ZZ-DR-A-01401.dwg		A348-MCO-XX-08-DR-A-21108	SCOPING THERMAL PLANS - LEVEL 08
41	40. A348-MCO-XX-ZZ-DR-A-01401.pdf		A348-MCO-XX-09-DR-A-21109	SCOPING THERMAL PLANS - LEVEL 09
42	41. A348-MCO-XX-ZZ-DR-A-01402.dwg		A348-MCO-XX-10-DR-A-21110	SCOPING THERMAL PLANS - LEVEL 10
43	42. A348-MCO-XX-ZZ-DR-A-01402.pdf		A348-MCO-XX-R1-DR-A-21111	SCOPING THERMAL PLANS - ROOF
44	43. A348-MCO-XX-ZZ-DR-A-01411.dwg		A348-MCO-XX-ZZ-DR-A-01201	GA NORTH ELEVATION
Sheet1

Cell Formulas
Range	Formula
B2:B44	B2	=XLOOKUP(LEFT(MID(A2,FIND(". ",A2)+2,LEN(A2)-FIND(". ",A2)+2),SEARCH("???.",MID(A2,FIND(". ",A2)+2,LEN(A2)-FIND(". ",A2)+2))-2),$C$2:$C$134,$D$2:$D$134,"")

 

[Sanjeev1976]

You can use the formula :

=XLOOKUP(TRIM(CHOOSECOLS(TEXTSPLIT(A2,"."),2)),$C$2:$C$134,$D$2:$D$134,"")

 

[Bravo661]

You can use the formula :

=XLOOKUP(TRIM(CHOOSECOLS(TEXTSPLIT(A2,"."),2)),$C$2:$C$134,$D$2:$D$134,"")

Unfortunately this does not appear to work.

 

[Sanjeev1976]

Like this :

Book1
	A	B	C	D
1	DOCUMENT LIST	MATCH RESULT	PARTIAL DOCUMENT NAME	DESCRIPTION TO ASSOCIATE WITH DOCUMENT LIST NAME
2	1. A348-MCO-XX-ZZ-DR-A-01201.dwg	GA NORTH ELEVATION	A348-MCO-XX-00-DR-A-01100	GA PLAN LEVEL 00 & MEZZANINE
3	2. A348-MCO-XX-ZZ-DR-A-01201.pdf	GA NORTH ELEVATION	A348-MCO-XX-01-DR-A-01101	GA PLAN LEVEL 01
4	3. A348-MCO-XX-ZZ-DR-A-01202.dwg	GA EAST (EAST WING) ELEVATION	A348-MCO-XX-02-DR-A-01102	GA PLAN LEVEL 02
5	4. A348-MCO-XX-ZZ-DR-A-01202.pdf	GA EAST (EAST WING) ELEVATION	A348-MCO-XX-03-DR-A-01103	GA PLAN LEVEL 03
6	5. A348-MCO-XX-ZZ-DR-A-01203.dwg		A348-MCO-XX-04-DR-A-01104	GA PLAN LEVEL 04
7	6. A348-MCO-XX-ZZ-DR-A-01203.pdf		A348-MCO-XX-05-DR-A-01105	GA PLAN LEVEL 05
8	7. A348-MCO-XX-ZZ-DR-A-01204.dwg	GA SOUTH ELEVATION	A348-MCO-XX-06-DR-A-01106	GA PLAN LEVEL 06
9	8. A348-MCO-XX-ZZ-DR-A-01204.pdf	GA SOUTH ELEVATION	A348-MCO-XX-07-DR-A-01107	GA PLAN LEVEL 07
10	9. A348-MCO-XX-ZZ-DR-A-01205.dwg	GA WEST (EAST WING) ELEVATION	A348-MCO-XX-08-DR-A-01108	GA PLAN LEVEL 08
11	10. A348-MCO-XX-ZZ-DR-A-01205.pdf	GA WEST (EAST WING) ELEVATION	A348-MCO-XX-09-DR-A-01109	GA PLAN LEVEL 09
12	11. A348-MCO-XX-ZZ-DR-A-01206.dwg	GA WEST (WEST WING) ELEVATION	A348-MCO-XX-10-DR-A-01110	GA PLAN LEVEL 10
13	12. A348-MCO-XX-ZZ-DR-A-01206.pdf	GA WEST (WEST WING) ELEVATION	A348-MCO-XX-R1-DR-A-01120	GA PLAN ROOF LEVEL
14	13. A348-MCO-XX-00-DR-A-01100.dwg	GA PLAN LEVEL 00 & MEZZANINE	A348-MCO-XX-ZZ-DR-A-01201	GA NORTH ELEVATION
15	14. A348-MCO-XX-00-DR-A-01100.pdf	GA PLAN LEVEL 00 & MEZZANINE	A348-MCO-XX-ZZ-DR-A-01202	GA EAST (EAST WING) ELEVATION
16	15. A348-MCO-XX-01-DR-A-01101.dwg	GA PLAN LEVEL 01	A348-MC0-XX-ZZ-DR-A-01203	GA EAST (WEST WING) ELEVATION
17	16. A348-MCO-XX-01-DR-A-01101.pdf	GA PLAN LEVEL 01	A348-MCO-XX-ZZ-DR-A-01204	GA SOUTH ELEVATION
18	17. A348-MCO-XX-02-DR-A-01102.dwg	GA PLAN LEVEL 02	A348-MCO-XX-ZZ-DR-A-01205	GA WEST (EAST WING) ELEVATION
19	18. A348-MCO-XX-02-DR-A-01102.pdf	GA PLAN LEVEL 02	A348-MCO-XX-ZZ-DR-A-01206	GA WEST (WEST WING) ELEVATION
20	19. A348-MCO-XX-03-DR-A-01103.dwg	GA PLAN LEVEL 03	A348-MCO-XX-ZZ-DR-A-01301	GA SECTION AA
21	20. A348-MCO-XX-03-DR-A-01103.pdf	GA PLAN LEVEL 03	A348-MCO-XX-ZZ-DR-A-01302	GA SECTION BB
22	21. A348-MCO-XX-05-DR-A-01105.dwg	GA PLAN LEVEL 05	A348-MCO-XX-ZZ-DR-A-01303	GA SECTION CC
23	22. A348-MCO-XX-05-DR-A-01105.pdf	GA PLAN LEVEL 05	A348-MCO-XX-ZZ-DR-A-01304	GA SECTION DD
24	23. A348-MCO-XX-06-DR-A-01106.dwg	GA PLAN LEVEL 06	A348-MCO-XX-ZZ-DR-A-01401	STUDENT RESIDENTIAL TYPES 01
25	24. A348-MCO-XX-06-DR-A-01106.pdf	GA PLAN LEVEL 06	A348-MCO-XX-ZZ-DR-A-01402	STUDENT RESIDENTIAL TYPES 02
26	25. A348-MCO-XX-07-DR-A-01107.dwg	GA PLAN LEVEL 07	A348-MCO-XX-ZZ-DR-A-01411	RESIDENTIAL TYPES
27	26. A348-MCO-XX-07-DR-A-01107.pdf	GA PLAN LEVEL 07	A348-MCO-XX-ZZ-DR-A-01450	STUDENT AND COMMERCIAL REFUSE
28	27. A348-MCO-XX-08-DR-A-01108.dwg	GA PLAN LEVEL 08	A348-MCO-XX-ZZ-DR-A-01452	OFFICE CYCLE STORE, RESIDENTIAL CYCLE STORE & LL
29	28. A348-MCO-XX-08-DR-A-01108.pdf	GA PLAN LEVEL 08	A348-MCO-XX-XX-DR-A-01460	VISUALS - STUDENT ROOM TYPES
30	29. A348-MCO-XX-09-DR-A-01109.dwg	GA PLAN LEVEL 09	A348-MCO-XX-XX-DR-A-01461	VISUALS - STUDENT ROOM TYPES
31	30. A348-MCO-XX-09-DR-A-01109.pdf	GA PLAN LEVEL 09	A348-MCO-XX-XX-DR-A-01462	VISUALS - KEY WORKER UNIT & PAVILIONS
32	31. A348-MCO-XX-10-DR-A-01110.dwg	GA PLAN LEVEL 10	A348-MCO-XX-XX-DR-A-01463	VISUALS - WORKSPACE
33	32. A348-MCO-XX-10-DR-A-01110.pdf	GA PLAN LEVEL 10	A348-MCO-XX-00-DR-A-21100	SCOPING THERMAL PLANS - LEVEL 00
34	33. A348-MCO-XX-R1-DR-A-01111.dwg		A348-MCO-XX-01-DR-A-21101	SCOPING THERMAL PLANS - LEVEL 01
35	34. A348-MCO-XX-R1-DR-A-01111.pdf		A348-MCO-XX-02-DR-A-21102	SCOPING THERMAL PLANS - LEVEL 02
36	35. A348-MCO-XX-XX-DR-A-01460.pdf	VISUALS - STUDENT ROOM TYPES	A348-MCO-XX-03-DR-A-21103	SCOPING THERMAL PLANS - LEVEL 03 & 04
37	36. A348-MCO-XX-XX-DR-A-01461.pdf	VISUALS - STUDENT ROOM TYPES	A348-MCO-XX-05-DR-A-S105	SCOPING THERMAL PLANS - LEVEL 05
38	37. A348-MCO-XX-XX-DR-A-01462.pdf	VISUALS - KEY WORKER UNIT & PAVILIONS	A348-MCO-XX-06-DR-A-21106	SCOPING THERMAL PLANS - LEVEL 06
39	38. A348-MCO-XX-XX-DR-A-01463.pdf	VISUALS - WORKSPACE	A348-MCO-XX-07-DR-A-21107	SCOPING THERMAL PLANS - LEVEL 07
40	39. A348-MCO-XX-ZZ-DR-A-01401.dwg	STUDENT RESIDENTIAL TYPES 01	A348-MCO-XX-08-DR-A-21108	SCOPING THERMAL PLANS - LEVEL 08
41	40. A348-MCO-XX-ZZ-DR-A-01401.pdf	STUDENT RESIDENTIAL TYPES 01	A348-MCO-XX-09-DR-A-21109	SCOPING THERMAL PLANS - LEVEL 09
42	41. A348-MCO-XX-ZZ-DR-A-01402.dwg	STUDENT RESIDENTIAL TYPES 02	A348-MCO-XX-10-DR-A-21110	SCOPING THERMAL PLANS - LEVEL 10
43	42. A348-MCO-XX-ZZ-DR-A-01402.pdf	STUDENT RESIDENTIAL TYPES 02	A348-MCO-XX-R1-DR-A-21111	SCOPING THERMAL PLANS - ROOF
44	43. A348-MCO-XX-ZZ-DR-A-01411.dwg	RESIDENTIAL TYPES	A348-MCO-XX-ZZ-DR-A-01201	GA NORTH ELEVATION
Sheet1

Cell Formulas
Range	Formula
B2:B44	B2	=XLOOKUP(TRIM(CHOOSECOLS(TEXTSPLIT(A2,"."),2)),$C$2:$C$134,$D$2:$D$134,"")

 

[FormR]

Hi, here's another option you could try:

Book2
	A	B	C	D
1	DOCUMENT LIST	Result	PARTIAL DOCUMENT NAME	DESCRIPTION TO ASSOCIATE WITH DOCUMENT LIST NAME
2	1. A348-MCO-XX-ZZ-DR-A-01201.dwg	GA NORTH ELEVATION	A348-MCO-XX-00-DR-A-01100	GA PLAN LEVEL 00 & MEZZANINE
3	2. A348-MCO-XX-ZZ-DR-A-01201.pdf	GA NORTH ELEVATION	A348-MCO-XX-01-DR-A-01101	GA PLAN LEVEL 01
4	3. A348-MCO-XX-ZZ-DR-A-01202.dwg	GA EAST (EAST WING) ELEVATION	A348-MCO-XX-02-DR-A-01102	GA PLAN LEVEL 02
5	4. A348-MCO-XX-ZZ-DR-A-01202.pdf	GA EAST (EAST WING) ELEVATION	A348-MCO-XX-03-DR-A-01103	GA PLAN LEVEL 03
6	5. A348-MCO-XX-ZZ-DR-A-01203.dwg		A348-MCO-XX-04-DR-A-01104	GA PLAN LEVEL 04
7	6. A348-MCO-XX-ZZ-DR-A-01203.pdf		A348-MCO-XX-05-DR-A-01105	GA PLAN LEVEL 05
8	7. A348-MCO-XX-ZZ-DR-A-01204.dwg	GA SOUTH ELEVATION	A348-MCO-XX-06-DR-A-01106	GA PLAN LEVEL 06
9	8. A348-MCO-XX-ZZ-DR-A-01204.pdf	GA SOUTH ELEVATION	A348-MCO-XX-07-DR-A-01107	GA PLAN LEVEL 07
10	9. A348-MCO-XX-ZZ-DR-A-01205.dwg	GA WEST (EAST WING) ELEVATION	A348-MCO-XX-08-DR-A-01108	GA PLAN LEVEL 08
11	10. A348-MCO-XX-ZZ-DR-A-01205.pdf	GA WEST (EAST WING) ELEVATION	A348-MCO-XX-09-DR-A-01109	GA PLAN LEVEL 09
12	11. A348-MCO-XX-ZZ-DR-A-01206.dwg	GA WEST (WEST WING) ELEVATION	A348-MCO-XX-10-DR-A-01110	GA PLAN LEVEL 10
13	12. A348-MCO-XX-ZZ-DR-A-01206.pdf	GA WEST (WEST WING) ELEVATION	A348-MCO-XX-R1-DR-A-01120	GA PLAN ROOF LEVEL
14	13. A348-MCO-XX-00-DR-A-01100.dwg	GA PLAN LEVEL 00 & MEZZANINE	A348-MCO-XX-ZZ-DR-A-01201	GA NORTH ELEVATION
15	14. A348-MCO-XX-00-DR-A-01100.pdf	GA PLAN LEVEL 00 & MEZZANINE	A348-MCO-XX-ZZ-DR-A-01202	GA EAST (EAST WING) ELEVATION
16	15. A348-MCO-XX-01-DR-A-01101.dwg	GA PLAN LEVEL 01	A348-MC0-XX-ZZ-DR-A-01203	GA EAST (WEST WING) ELEVATION
17	16. A348-MCO-XX-01-DR-A-01101.pdf	GA PLAN LEVEL 01	A348-MCO-XX-ZZ-DR-A-01204	GA SOUTH ELEVATION
18	17. A348-MCO-XX-02-DR-A-01102.dwg	GA PLAN LEVEL 02	A348-MCO-XX-ZZ-DR-A-01205	GA WEST (EAST WING) ELEVATION
19	18. A348-MCO-XX-02-DR-A-01102.pdf	GA PLAN LEVEL 02	A348-MCO-XX-ZZ-DR-A-01206	GA WEST (WEST WING) ELEVATION
20	19. A348-MCO-XX-03-DR-A-01103.dwg	GA PLAN LEVEL 03	A348-MCO-XX-ZZ-DR-A-01301	GA SECTION AA
21	20. A348-MCO-XX-03-DR-A-01103.pdf	GA PLAN LEVEL 03	A348-MCO-XX-ZZ-DR-A-01302	GA SECTION BB
22	21. A348-MCO-XX-05-DR-A-01105.dwg	GA PLAN LEVEL 05	A348-MCO-XX-ZZ-DR-A-01303	GA SECTION CC
23	22. A348-MCO-XX-05-DR-A-01105.pdf	GA PLAN LEVEL 05	A348-MCO-XX-ZZ-DR-A-01304	GA SECTION DD
24	23. A348-MCO-XX-06-DR-A-01106.dwg	GA PLAN LEVEL 06	A348-MCO-XX-ZZ-DR-A-01401	STUDENT RESIDENTIAL TYPES 01
25	24. A348-MCO-XX-06-DR-A-01106.pdf	GA PLAN LEVEL 06	A348-MCO-XX-ZZ-DR-A-01402	STUDENT RESIDENTIAL TYPES 02
26	25. A348-MCO-XX-07-DR-A-01107.dwg	GA PLAN LEVEL 07	A348-MCO-XX-ZZ-DR-A-01411	RESIDENTIAL TYPES
27	26. A348-MCO-XX-07-DR-A-01107.pdf	GA PLAN LEVEL 07	A348-MCO-XX-ZZ-DR-A-01450	STUDENT AND COMMERCIAL REFUSE
28	27. A348-MCO-XX-08-DR-A-01108.dwg	GA PLAN LEVEL 08	A348-MCO-XX-ZZ-DR-A-01452	OFFICE CYCLE STORE, RESIDENTIAL CYCLE STORE & LL
29	28. A348-MCO-XX-08-DR-A-01108.pdf	GA PLAN LEVEL 08	A348-MCO-XX-XX-DR-A-01460	VISUALS - STUDENT ROOM TYPES
30	29. A348-MCO-XX-09-DR-A-01109.dwg	GA PLAN LEVEL 09	A348-MCO-XX-XX-DR-A-01461	VISUALS - STUDENT ROOM TYPES
31	30. A348-MCO-XX-09-DR-A-01109.pdf	GA PLAN LEVEL 09	A348-MCO-XX-XX-DR-A-01462	VISUALS - KEY WORKER UNIT & PAVILIONS
32	31. A348-MCO-XX-10-DR-A-01110.dwg	GA PLAN LEVEL 10	A348-MCO-XX-XX-DR-A-01463	VISUALS - WORKSPACE
33	32. A348-MCO-XX-10-DR-A-01110.pdf	GA PLAN LEVEL 10	A348-MCO-XX-00-DR-A-21100	SCOPING THERMAL PLANS - LEVEL 00
34	33. A348-MCO-XX-R1-DR-A-01111.dwg		A348-MCO-XX-01-DR-A-21101	SCOPING THERMAL PLANS - LEVEL 01
35	34. A348-MCO-XX-R1-DR-A-01111.pdf		A348-MCO-XX-02-DR-A-21102	SCOPING THERMAL PLANS - LEVEL 02
36	35. A348-MCO-XX-XX-DR-A-01460.pdf	VISUALS - STUDENT ROOM TYPES	A348-MCO-XX-03-DR-A-21103	SCOPING THERMAL PLANS - LEVEL 03 & 04
37	36. A348-MCO-XX-XX-DR-A-01461.pdf	VISUALS - STUDENT ROOM TYPES	A348-MCO-XX-05-DR-A-S105	SCOPING THERMAL PLANS - LEVEL 05
38	37. A348-MCO-XX-XX-DR-A-01462.pdf	VISUALS - KEY WORKER UNIT & PAVILIONS	A348-MCO-XX-06-DR-A-21106	SCOPING THERMAL PLANS - LEVEL 06
39	38. A348-MCO-XX-XX-DR-A-01463.pdf	VISUALS - WORKSPACE	A348-MCO-XX-07-DR-A-21107	SCOPING THERMAL PLANS - LEVEL 07
40	39. A348-MCO-XX-ZZ-DR-A-01401.dwg	STUDENT RESIDENTIAL TYPES 01	A348-MCO-XX-08-DR-A-21108	SCOPING THERMAL PLANS - LEVEL 08
41	40. A348-MCO-XX-ZZ-DR-A-01401.pdf	STUDENT RESIDENTIAL TYPES 01	A348-MCO-XX-09-DR-A-21109	SCOPING THERMAL PLANS - LEVEL 09
42	41. A348-MCO-XX-ZZ-DR-A-01402.dwg	STUDENT RESIDENTIAL TYPES 02	A348-MCO-XX-10-DR-A-21110	SCOPING THERMAL PLANS - LEVEL 10
43	42. A348-MCO-XX-ZZ-DR-A-01402.pdf	STUDENT RESIDENTIAL TYPES 02	A348-MCO-XX-R1-DR-A-21111	SCOPING THERMAL PLANS - ROOF
44	43. A348-MCO-XX-ZZ-DR-A-01411.dwg	RESIDENTIAL TYPES	A348-MCO-XX-ZZ-DR-A-01201	GA NORTH ELEVATION
45	28. 5718-WAL-ZZ-06-DR-S-1400_T01.dwg		5718-WAL-ZZ-ZZ-DR-S-2006	BUILDING SECTIONS SHEET 6
46	29. 5718-WAL-ZZ-07-DR-S-1100-T01.dwg		5718-WAL-ZZ-ZZ-DR-S-2007	BUILDING SECTIONS SHEET 7
47	3. 5718-WAL-ZZ-00-DR-S-1400-T01.pdf		5718-WAL-ZZ-ZZ-DR-S-2010	SUBSTRUCTURE DETAIL SECTIONS
48	30. 5718-WAL-ZZ-07-DR-S-1100-T01.pdf		5718-WAL-ZZ-ZZ-DR-S-2100	CORE 1 WALL ELEVATIONS
49	31. 5718-WAL-ZZ-07-DR-S-1400-T01.pdf		5718-WAL-ZZ-ZZ-DR-S-2105	CORE 2 WALL ELEVATIONS
50	32. 5718-WAL-ZZ-07-DR-S-1400_T01.dwg		5718-WAL-ZZ-ZZ-DR-S-2110	CORE 3 WALL ELEVATIONS
51	33. 5718-WAL-ZZ-08-DR-S-1100-T01.dwg		5718-WAL-ZZ-ZZ-DR-S-2115	CORE 4 WALL ELEVATIONS SHEET 1
52	34. 5718-WAL-ZZ-08-DR-S-1100-T01.pdf		5718-WAL-ZZ-ZZ-DR-S-2116	CORE 4 WALL ELEVATIONS SHEET 2
Sheet1

Cell Formulas
Range	Formula
B2:B52	B2	=XLOOKUP(TRUE,ISNUMBER(SEARCH($C$2:$C$52,A2)),$D$2:$D$52,"")