SOLVED

# ** HELP ** Formula based on drop down list

Copper Contributor

# ** HELP ** Formula based on drop down list

Hi All,

@Hans Vogelaar@Sergei Baklan

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:

best response confirmed by sbruk89 (Copper Contributor)
Solution

# Re: ** HELP ** Formula based on drop down list

=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 best response

Accepted Solutions
best response confirmed by sbruk89 (Copper Contributor)
Solution

# Re: ** HELP ** Formula based on drop down list

=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")), ""))