I have 2 tables in Excel and I am trying (via Excel formula) to match/align some rows (ones that contain identical letters for the sake of the example included below). Btw, I don't mind aligning Table 2 with 1 or even creating a 3rd Table as long as it aligns with table 1. How can I achieve this?

I have tried the following formula but I have to repeat it across cells to create a row and drag-down (copy downwards):

=IFERROR(VLOOKUP($A1,Array,1,FALSE)," ")

=IFERROR(VLOOKUP($A1,Array,2,FALSE)," ")

=IFERROR(VLOOKUP($A1,Array,3,FALSE)," ") [this would show the 3rd cell in a row]

I am guessing there could be a more easier way.

Example: Trying to transform the tables below,

```
{TABLE 1} {TABLE 2}
Z 4 1 F 4 8
A 4 9 B 7 2
B 3 7 A 3 9
L 3 9 G 3 5
D 4 2 M 7 2
F 4 2 D 1 3
```

into the tables below

```
{TABLE 1} {TABLE 3}
Z 4 1 (gap is left for unmatched rows)
A 4 9 A 3 5 (matched and aligned)
B 3 7 B 6 2 (matched and aligned)
L 3 9 (gap is left for unmatched rows)
D 4 2 D 1 3 (matched and aligned)
F 4 2 and F 0 8 (matched and aligned)
G 3 5 (unmatched and separated)
M 7 2 (unmatched and separated)
```