Need help making a routing table

[tpthatsme]

Hello Excel and VBA Experts
I have a challenging problem to automate a routing table. I am given data with missing users names and the routing table to determine the user names, and I can’t change how the information is presented.

The data with missing user names has 5 fields; for this example we will call them Card Suits, Elements, Planets, States, and Number where Number is a 5 digit string that is mostly numbers, but could contain a letter.

The routing table that I have has all of these fields as options but not all fields need to contain data. Additionally, the Number is broken up into 5 fields to represent parts of the string. The 5 fields would be something like a Left Function. So if the second number field was 12, this would mean every 5 digit string that begins with the characters 12, like 12345 or 1209Z. Please see the example below for a better understanding. Any help would be great!

This is the data that I am given
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Card Suits[/TD]
[TD]Elements[/TD]
[TD]Planets[/TD]
[TD]States[/TD]
[TD]Number[/TD]
[/TR]
[TR]
[TD]Hearts[/TD]
[TD]Lead[/TD]
[TD]Earth[/TD]
[TD]Texas[/TD]
[TD]12345[/TD]
[/TR]
</tbody>[/TABLE]

This is the routing table
[TABLE="class: grid, width: 700"]
<tbody>[TR]
[TD]Card Suits[/TD]
[TD]Elements[/TD]
[TD]Planets[/TD]
[TD]States[/TD]
[TD]Num1[/TD]
[TD]Num2[/TD]
[TD]Num3[/TD]
[TD]Num4[/TD]
[TD]Num5[/TD]
[TD]User[/TD]
[/TR]
[TR]
[TD]Hearts[/TD]
[TD]Lead[/TD]
[TD]Earth[/TD]
[TD]Texas[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]12345[/TD]
[TD]Jon Snow[/TD]
[/TR]
[TR]
[TD]Hearts[/TD]
[TD]Lead[/TD]
[TD]Earth[/TD]
[TD][/TD]
[TD][/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Bran Stark[/TD]
[/TR]
[TR]
[TD]Hearts[/TD]
[TD][/TD]
[TD]Earth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Robert Baratheon[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Lead[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Jaime Lannister[/TD]
[/TR]
</tbody>[/TABLE]