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
mathetes's avatar
mathetes
Silver Contributor
Dec 14, 2023

brianlv 

 

You would help us help you by posting copies of the actual workbook(s) on OneDrive or GoogleDrive. Images are helpful, but nowhere near as much as the actual thing.

 

Just be sure to delete or anonymize any confidential or proprietary information first. Then paste a link here that grants access.

  • 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.

     

    Example  


    thanks

    • mathetes's avatar
      mathetes
      Silver 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,

Resources