politicalangel
New Member
Does anyone have a formula I can use that will be able to pull values based on multiple drop downs?
My data is over 2000000 lines- I am trying to create a summary sheet where we use the drop down to summarize by region travel expenses on a monthly basis.
Im trying not to use a Pivot
I am looking for J9 downwards to populate with the names of the individuals based on the Selected Region, Selected Category and selected Job title (if you can make the drop down dependent even better)
Thanks in Advance
My data is over 2000000 lines- I am trying to create a summary sheet where we use the drop down to summarize by region travel expenses on a monthly basis.
Im trying not to use a Pivot
I am looking for J9 downwards to populate with the names of the individuals based on the Selected Region, Selected Category and selected Job title (if you can make the drop down dependent even better)
Thanks in Advance