Forum Discussion

sf49ers19238597's avatar
sf49ers19238597
Iron Contributor
Jan 20, 2025

I need help with three difference searchable dropdown lists

I need help with three searchable dropdown lists on a team info worksheet. I want to make the work searchable with no repetition. The list goes on the worksheets. When a team is picked, the team will...
excel
Formulas and Functions
m_tarler's avatar
m_tarler
Bronze Contributor
Feb 05, 2025

I'm sorry I don't understand what you are saying.

If you provide an updated file I can work on that.  I just don't know what is the problem you are having.

sf49ers19238597's avatar
sf49ers19238597
Iron Contributor
Feb 07, 2025

I am sending upadate with bye weeks is empty put team in cell then next cell down try find the same team you pick it should not be on the list anymore. I try to do samething on the NFL schedules files. I getting to work. I try out formula or formulas. Look at NFL schedule first. I want update file NFL schedules same as nfl schedule on bye weeks.  The formulas is on Teams infos worksheets for bye weeks and playoffs worksheets.

 

 

Thank You

  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    Feb 07, 2025

    I don't see any file attached.  In the old file I have and attached above those areas still work as you had them.  I suspect in the new file the NAME isn't set right.  It is looking at a name "NFL_PLAYOFFS_AREA".  Check the name manger that it is set correctly:

     

Resources