muhleebbin
Active Member
- Joined
- Sep 30, 2017
- Messages
- 252
- Office Version
- 365
- 2019
- 2016
- 2013
- 2010
- Platform
- Windows
- MacOS
- Mobile
- Web
Is it possible to look up within multiple columns and return the rows that have data if that column is selected in another field?
Example data would be something like columns c1-z1 having values 1-24. If rows 2-100 had 'x' or any other value indicating they fit that column, would it be possible to have sheet 2 cell a1 have a drop down menu of 1-24 and whichever it selects bring up the rows that actually fit that selected column?
Example data would be something like columns c1-z1 having values 1-24. If rows 2-100 had 'x' or any other value indicating they fit that column, would it be possible to have sheet 2 cell a1 have a drop down menu of 1-24 and whichever it selects bring up the rows that actually fit that selected column?