Like this?
=FILTER(H3:H15,(F3:F15=A3)*(G3:G15=B3)) (say this formula is in cell C13)
You can then reference the output in the data validation list for the dropdown via =C13#
Like this?
=FILTER(H3:H15,(F3:F15=A3)*(G3:G15=B3)) (say this formula is in cell C13)
You can then reference the output in the data validation list for the dropdown via =C13#
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks