Huge problem with the INDIRECT function, trying to create dependent drop downs

[Quillow]

Okay, so, I'm trying to create a series of dependent drop down lists.
I want to be able to select the Activity from a range of R functions, which would then give me a list of Project #'s, and then give me an option of the description.

Example:
I want to be able to select a code from a drop down list of these named "Activity":
CodeR110
CodeR210
CodeR310
CodeR410
CodeR510

If I select CodeR110 I want to be given an option of these numbers, named "CodeR110"
701
702
703
704
706
707
708
709
710
711
712
713
714
715

Then when I select number 701 I should then be given another list of these named "Description"
Executive Director
Marketing and Communications Manager
Office Administrator
Operations Manager

This function should also be able to relate back, like if I select "701" from the CodeR110 list it should give me the proper description and Activity

I can't seem to get this to work! I can't even get CodeR110 to redirect to a listing of CodeR110 project numbers!

Here's what I have so far:
Pcard- Amounts Removed.xlsx

[TMS]

Provided the named ranges CodeR110, CodeR210, etc., match the entries in the initial drop down list, it's just:

Please Login or Register  to view this content.

Regards, TMS

[Quillow]

It's not working. Instead of giving me a drop-down list it just says: =INDIRECT($H7)

Edit: Put the equals sign on the wrong side.

[Quillow]

Here is what the excel sheet currently looks like:
Indirect Function.png

[Quillow]

Nevermind, I just figured it out. My cell value was set to TEXT instead of GENERAL so the INDIRECT function was just displaying and not working as a function. My lists are now working! Huzzah!

[TMS]

You're welcome.