[SOLVED] Help with dropdowns and fetching info via INDIRECT

Hi folks, having an issue and could use some insight - my skills are average but have cobbled a workbook together with the help of google. Because of my skill level I can't see what the issue is/may be. This is time sensitive, so help is very much appreciated.

I have dependant dropdowns where it's working for all but 2 items and I can't figure out why. As far as I know I've set everything up the same.

To see the issue go to sheet 'Pricing Info'. The dropdown in A1 is a list of session types. All the dropdowns in row 8 of the same sheet should be dependant on the dropdown in A1 and pull the appropriate info. If you try the dropdowns in Row 8 as uploaded (on "Headshots") it works. If you change the dropdown in A1 to either "Cakesmash" or "Kids" none of the dropdowns in Row 8 work.

Please see below for further info

Cell A1 on 'Pricing Info' is a drop down of different session types. The session types are derrived from a UNIQUE formula sitting on 'list_data' sheet and come from Column B on sheet 'Packages Info'.

In Row 8 on sheet 'Pricing Info' there is then another dropdown that is dependant on the drop down in A1 which contains INDIRECT and should pull the data from the 'Packages Info' sheet.

All session/package types work except for "Kids" and "Cakesmash" and I cannot figure out why. Can anyone help?


(Ignore the #REF error on sheet 'Pricing Info', I've deleted some sheets to minimize confusion.)

There's no named range called 'Kids' and there's no named range called 'CakeSmash'.

If I change names of the named ranges called 'Kids_Teens_Grad' and 'Cake_Smash' to 'Kids' and 'CakeSmash' respectively the dropdowns appear to work.