I'm trying to enter serial numbers in column A and have a drop down list of options in column B.

8 different types of serial numbers and 5 different options lists for them

I think I want to use INDIRECT(VLOOKUP(... but I need to look for serial numbers starting with an X (for example) instead of just look for certain text.

This will explain more: Dependent Drop Down.xlsx