Hi there,
I think we could work out a solution fairly quickly. I'd imagine it will be a combination of if formulas and index/match or lookup formulas to get you what you need. Is your data set very large? I work with a lot of large data sets for my current job where I need to find very specific data based on categories like country, month/quarter, product category, etc.
Could we discuss in further detail and get started?
Thanks!
Thomas