Assuming you want the results for the data as shown
ListAN ListAL ListBN ListBL ResultBN ResultBL
1 L 1 D 1 D
2 M 2 E 2 E
3 N 3 F 3 F
4 O 5 G
5 P 6 H 5 G
6 Q 7 I 6 H
7 R 8 J 7 I
8 S 10 K 8 J
9 T 11 L
10 U 12 M 10 K
11 V 13 N 11 L
12 W 14 O 12 M
14 X 15 P 14 O
15 Y 17 Q 15 P
16 Z 20 R
17 A 21 S 17 Q
18 B 22 T
19 C 23 U
20 D 24 V 20 R
21 E 25 W 21 S
Name the columns as shown.
Enter these formulas into ResultBN and ResultBL respectively
=IF(COUNTIF(ListBN,ListAN)=0,"",ListAN)
=IF(ISNUMBER(ResultBN),LOOKUP(ResultBN,ListBN,List BL),"")