I hope I can describe this in a way that makes sense.
I'm trying to make it so 'spreadsheet b'!D2 is a dropdown list of all the text based options on 'spreadsheet d'! B2:B100 where the value in 'spreadsheet d'!A2:A100 = 'spreadsheet b'!C2
I'm familiar with using the data validation to create a dropdown list from a range of values, but I'm unsure of how to add conditions on the values being displayed.
Any help or guidance would be greatly appreciated.
Bookmarks