oblix
Board Regular
- Joined
- Mar 29, 2017
- Messages
- 183
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Platform
- Windows
- MacOS
- Mobile
- Web
Hi there
in sheet3 I have this
I am trying to create drop down lists in column c, d, g and so on based on looking up what is in columnb, matching it to column b in sheet4 and returning all items in column c that match in sheet4 . here is sheet4
:
What should the formula in the data validation be to make this work?
in sheet3 I have this
I am trying to create drop down lists in column c, d, g and so on based on looking up what is in columnb, matching it to column b in sheet4 and returning all items in column c that match in sheet4 . here is sheet4
:
What should the formula in the data validation be to make this work?