Forum Discussion
** 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 Global Platform and Cell C7 is Equal to Launches but the value in Cell E7 is Global i want it to then look on tab Cataologue and pull back the relevant information (Image 2). so where there is a Y, YF or YA in the column for "global" it will then return the values in Column D
Image 1:
Image 2:
=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")), ""))
1 Reply
=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")), ""))