Display Table via Dropdown. Vlookup across multiple tables.

Hello Everyone!

First time Forum poster here. Long time forum reader though.
I was not able to find exactly what I needed by searching. I have a hard time describing exactly what I am trying to do.
Also Please give suggestions as to what I should rename the title description to so that other users can find this info faster.

So please bear with as I'm going to jump right in.



Attached at the bottom is the Test file.xlsx which shows the 3 different scenario's I'm having difficulty with.

Scenario # ....
#1. Click B3 and select 1 of 3 options. I would like the entire data for that customer to display in the red area.
The table containing the data is located in columns F - H.
What I'm trying to achieve.... I have 100 customers with 100 different pricing strategies. I want to be able to select a customer from a dropdown and his entire price list populate.
Simply Filtering the Table is not an option.

#2. Same as scenario 1 except table has been divided per customer.

#3. I will have 3 pricing files similar to Special, Normal, MSRP. I need Vlookup to look in Special first. If not found then look in Normal, If not found then use MSRP.
Even if the pricing happens to be higher in "special" I need that value returned first. I used "lime" as my example.
I also used "watermelon" as my example of something not found in Special or Normal tables.
I inserted the initial Vlookup function but it only looks in table "special"

Thanks in advance!
Drew Eckstrom