Excel list box based on conditional if statements 1

[Luvsql]

I've been googling this for hours and still haven't come up with a solution. I have a spreadsheet, which first prompts the user for a "Department". After they choose that, they'll then be prompted for a "Category." I have all the categories per department listed in Sheet 2. The list box is not to list everything, but is dependent on which department they choose. The categories if the department is Dollies has been named DollyCat on Sheet 2, LIGHTING/GRIP has been name LGCat etc.

I've tried something like this, but it does nothing:

=IF(E2="DOLLIES",DollyCat,IF(E2="LIGHTING/GRIP",LGCat,IF(E2="THEATRE",TheatreCat)))

 

[SkipVought]

Hi,

Check out the approch in thread68-1541507.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[Luvsql]

I just couldn't get my mind around that formual, so I used the INDIRECT function, which worked perfectly.

http://www.contextures.com/xlDataval02.html