SOLVED

** HELP ** Formula based on drop down list

Copper Contributor

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:

sbruk89_0-1715950409277.png

Image 2:

sbruk89_1-1715950722584.png

 

 




1 Reply
best response confirmed by sbruk89 (Copper Contributor)
Solution

@sbruk89 

 

=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

@sbruk89 

 

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

View solution in original post