Forum Discussion
Lookup Value Based on 2 Citeria and Multiple Tables
I have a need to narrow down and select information based on criteria selections.
Step 1 lookup the discipline (civil) and return the abbreviation code (C), not shown.
Step 2 select the group that is a subset of civil (roadway) and return the abbreviation code (RD)
Step 3 select the sheet type that is a subset of discipline (civil) and group (roadway) and return the abbreviation code, such as detail (DTL).
The blue area is user input with drop down lists. The orange is where I need the correct codes to show so that it can all be combined to create the file name.
Your ideas are appreciated.
3 Replies
- Create a flat table with only these columns (repeat the information in a column if there are multiple items in the subsequent columns):
Discipline
Discipline Code
Abbreviation
Abbreviation code
Group
Group Code
Once that is in place you can simply use a handful of Slicers to filter this table.Thank you for the response. The slicers are a great tool. However, how do i apply them to 1000 rows that will be different for each row?
- Not sure what you mean?
