VLOOKUP & Lists

Pls can someone help with the following:

I have a range called List that has 3 columns of data:


Corporate Human Resources Services PMA
Corporate Procurement Director
Ops Central Customer Services Lost Property Office
Ops Travel Information Travel Info Call Ctr
Ops Travel Information Centres Travel Info Centres

I have 3 columns on the entry sheet called Business Unit (Col A), Department(Col B) and Sub-Department (Col C). I want to limit the choice in column B to based on the selection in Column A in the form of a drop-down list e.g choosing Corporate gives a list of Human Resources Services; Procurement.

I am using the list option for field validation and the following formula in cell B2:

=INDIRECT(VLOOKUP(A2,List,2,0))

I'm not sure what I'm doing wrong as I don't get a list of options just a blank cell. Do I need to use a different formula other than VLOOKUP..?


TIA

Have a look here:

Dependent Lists

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save