jono123445
New Member
- Joined
- Mar 6, 2020
- Messages
- 2
- Office Version
- 2019
=INDEX(O:O,MATCH(A4,Q:Q,0),1)
If the value of A4 (which has a drop down list with multiple possible values) matches the value of a cell in row Q, I need a drop down list with the corresponding values of row O.
With the above formula, I only get a drop down list with the first value that meets the criteria.
Is there a way of getting all values that meet the criteria to appear in the drop down list?
Many thanks in advance!
If the value of A4 (which has a drop down list with multiple possible values) matches the value of a cell in row Q, I need a drop down list with the corresponding values of row O.
With the above formula, I only get a drop down list with the first value that meets the criteria.
Is there a way of getting all values that meet the criteria to appear in the drop down list?
Many thanks in advance!