Need help making a routing table

tpthatsme

New Member
Joined
Jun 2, 2016
Messages
12
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>
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Watch MrExcel Video

Forum statistics

Threads
1,102,344
Messages
5,486,307
Members
407,538
Latest member
kbendelac

This Week's Hot Topics

Top