I have a Table1 of Raw data with a Customer # so 8 characters long.
As I created the Table for the use of creating a unique drop-down with no duplicates - then to create a LOOKUP to get a Carrier Name.

DB.JPG

From that Table I create a Formula in another sheet to pull the Customer# to create a list w/out duplicates

You see the 8 character 33* type. Keep that in mind.

When I use a LOOKUP - my goal is to get the Carrier Name.

In the Table1 - i'm going to change a Number to 33700005

Add_Num_toDB.JPG

Then go to my Table with the LOOKUP

Add_Num - DB View.JPG

As you see it works -

Now I remove the 5

Lookup_DB.JPG

???????

What is going on?
Even if I type 12345678 it doesn't work - so it's not exactly an 8 digit issue.

1. I have refreshed the table each time
2. I tried many numbers (32345678)

UGH! So while Typing this out - I just tested something and here is what's going on and maybe you can help me:

1. The Table1 & the Lookup are conflicting with SORT ASCENDING

So while the above was not working - I realized that the # in the first Cell was the lowest. So ANY number I used above that would work.

When I Sort-Ascend - It all showed up perfectly~

WHY?
Why Do I have to have the sort to work?