Forum Discussion
Solved
** HELP ** Formula based on drop down list
Hi All, HansVogelaar/ SergeiBaklan I want to generate a specific value based on certain criteria being met example below Image 1: So in this example, if the value in Cell A7 is Equal to Glo...
=LET(col, INDEX(Catalogue!G3:N1000, 0, MATCH(E7, Catalogue!G2:N2, 0)), FILTER(col, (Catalogue!A3:A1000=A7)*(Catalogue!B3:B1000=C7)*((col="Y")+(col="YF")+(col="YA")), ""))
=LET(col, INDEX(Catalogue!G3:N1000, 0, MATCH(E7, Catalogue!G2:N2, 0)), FILTER(col, (Catalogue!A3:A1000=A7)*(Catalogue!B3:B1000=C7)*((col="Y")+(col="YF")+(col="YA")), ""))