Forum Discussion
FILTER formula with criteria not working
mathetes Thanks for the reply, apologies, I meant to unhide those sheets but I must not have hit Save.
yes, I'm familiar with databases in a passing manner; more in that I understand the logic than any skills in building them. The goal is for this sheet to eventually be uploaded into a Vendor management module (hence my attempting to lay it out as close to import format as possible) but that is month's down the road and I've been tasked to develop an interim solution.
I've never used FILTER function before as I've only just gotten on 365. so it only searches one table at a time? How would I create a single criteria search? say the company name against the branch location? Could I then apply INDEX Match to the other columns to pull the relevant contact information?
I've also never used Power Query, but it does sound like that may be more in line with what I need? I wish I could put this on a single master table but in the full database I have 225 branches, ~400 vendors and 12 work types that could apply to each vendor... I can't think of a way to get it in any other format....
It could be that my most simple stopgap solution is a tiny little baby Access Database but i'm trying to avoid that if I can.
Thanks for the response!
I learned about FILTER (along with a couple other of the Dynamic Array functions) from this video. After that, it was all trial and error, but the video is great. https://www.youtube.com/watch?v=9I9DtFOVPIg
And I wondered about Access: haven't used it in years (having retired nearly 20 years ago, I just work with my own files now, so don't really need that kind of power).....I too have more of a "logic" connection with relational databases than an actual hands on, at least current. Back thirty years ago I was pretty good with SQL, querying an IBM mainframe database, extracting data to Excel (or Access), and was involved as the director (on the client side) of an HR and Payroll database for a major corporation.....so I learned some of the jargon as well as actually just having fun. The logic of normalization of a database is quite fascinating.....and for the sake of efficiency may be exactly what you need. Power Query does make it possible, from what I understand, within Excel.....so best wishes.