Need help making a routing table

tpthatsme

New Member
Joined
Jun 2, 2016
Messages
10
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
Card SuitsElementsPlanetsStatesNumber
HeartsLeadEarthTexas12345

<tbody>
</tbody>

This is the routing table
Card SuitsElementsPlanetsStatesNum1Num2Num3Num4Num5User
HeartsLeadEarthTexas12345Jon Snow
HeartsLeadEarth12Bran Stark
HeartsEarthRobert Baratheon
LeadJaime Lannister

<tbody>
</tbody>
 

Forum statistics

Threads
1,077,687
Messages
5,335,662
Members
399,032
Latest member
thefinu

Some videos you may like

This Week's Hot Topics

Top