Forum Discussion

brianlv's avatar
brianlv
Copper Contributor
Dec 12, 2023

Excel Tables - Table Data based on Another Table

I am sure its easier than I think, but I can't figure out how.    I have a main table (table 1) with data for multiple events. Some of those events we need to get permits for (say all the ones that...
excel
Excel for web
Formulas and Functions
office 365
brianlv's avatar
brianlv
Copper Contributor
Dec 14, 2023

mathetes definitely understand. here is an example, if something doesnt make sense, let me know and i will try to explain it better.

 

https://docs.google.com/spreadsheets/d/1Nvp2TE9HDvIWgKZ6q_Lw4lqCWOG-0wvm/edit?usp=sharing&ouid=103253656502323059392&rtpof=true&sd=true 


thanks

mathetes's avatar
mathetes
Gold Contributor
Dec 14, 2023

brianlv 

 

That link takes me to google, but it doesn't grant access. You need to create a different kind of link.

 

  • brianlv's avatar
    brianlv
    Copper Contributor
    Dec 14, 2023
    i updated the access levels for the link. should be able to open it now. i didnt realize it wouldnt allow access if i provided the direct link.

    thanks,
    • mathetes's avatar
      mathetes
      Gold Contributor
      Dec 14, 2023

      brianlv 

       

      Mixing Input and Output on single sheets, especially when they're essentially the same kinds of lists, and unavoidably when you're expecting (miraculously) that each will update the other, just makes for trouble.  

       

      I would strongly suggest that you make Input (or "RawData") a sheet of its own, and do ALL input on that sheet. Then have either:

      • a single "dynamic" output sheet, where you can select any given city from the rawData sheet, and get a display of all the data for that city, or
      • individual sheets for each city displaying the data for that city.

      See the attached example.

Resources