So I used a filter function formula to filter data based on specific category or vendor name like so:

However, what I realized is that what this filters is readable data not editable data. If I wanted to edit the data I would have to go to a different tab where the table resides and make the necessary changes which will automatically update when going back to the readable data tab like I showed in the image above. 

My question is, is there a way to use a drop down list to directly filter a table that way I would be able to edit and filter my table in the same tab? Like this for example which I photoshoped together:

 So if there is something I can put in the actual Filter function formula that can make what I’m asking work that maybe you excel experts might know and tell me that would be great. By the way this is my filter function formula: =FILTER(FilterTest,(FilterTest[Category]=L3)+(FilterTest[Vendor]=L4),””).

Although if its not possible using the filter function formula maybe you excel experts might have a tutorial video link that I can watch that will help me with trying to solve this problem.

I’ve spent days and hours trying to find videos or forums but I have had no luck.

Thank you and I look forward to your help

​So I used a filter function formula to filter data based on specific category or vendor name like so:However, what I realized is that what this filters is readable data not editable data. If I wanted to edit the data I would have to go to a different tab where the table resides and make the necessary changes which will automatically update when going back to the readable data tab like I showed in the image above.  My question is, is there a way to use a drop down list to directly filter a table that way I would be able to edit and filter my table in the same tab? Like this for example which I photoshoped together: So if there is something I can put in the actual Filter function formula that can make what I’m asking work that maybe you excel experts might know and tell me that would be great. By the way this is my filter function formula: =FILTER(FilterTest,(FilterTest[Category]=L3)+(FilterTest[Vendor]=L4),””). Although if its not possible using the filter function formula maybe you excel experts might have a tutorial video link that I can watch that will help me with trying to solve this problem. I’ve spent days and hours trying to find videos or forums but I have had no luck. Thank you and I look forward to your help  Read More

​