Hi,
I have made an example workbook
example workbook.xlsx
In cell D4 I would like to make a data validation list (dropdown) that would only show the animals with the color specified in the data validation list in cell C4 (based on the table below).
It also needs to be noted that the number of animals/entries are "unknown", i.e. I would like to use cell B4 as an offset (see data validation list formula for D4).
Thankful for any help.
Bookmarks