Auto Inserting numbers

B

Buildscharacter

I have two large lists of numbers with corresponding data in the cell
adjacent to them. I would like the list of numbers to match (inserting
cells where there are gaps). Is there any way to quickly and easily do
this?

For Example:

1 a 1
2 b 2
3 c 4
4 d 5
5 e 6
6 f 7

I would like it to automaticalls insert a space where the "3" should be
in the 3rd collumn. Thanks.
 
H

Herbert Seidenberg

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,ListBL),"")
 
Top