CHOOSECOLS/FILTER/HSTACK question

[Jedi Master]

I have one sheet that looks like thisresource role values are static here and I only want to pull the ones that have corresponding resource count values below) This snip sheet name: Quote Task Master

and another I want to pull filtered values into from the first, that would look like this if done correctly: This snip sheet name: 2-Quote Master

Is there a version of this formula that would accomplish the above?:

=LET(x,XLOOKUP($G11,'PM Project Tracker'!M4:UM4,'PM Project Tracker'!M9:UM21),IF($G11="","",CHOOSECOLS(FILTER(HSTACK('PM Project Tracker'!B9:C21,x),x>0),2,1,3)))

 

[Jedi Master]

I have one sheet that looks like thisresource role values are static here and I only want to pull the ones that have corresponding resource count values below) This snip sheet name: Quote Task Master
View attachment 113540
and another I want to pull filtered values into from the first, that would look like this if done correctly: This snip sheet name: 2-Quote Master
View attachment 113541

Is there a version of this formula that would accomplish the above?:

=LET(x,XLOOKUP($G11,'PM Project Tracker'!M4:UM4,'PM Project Tracker'!M9:UM21),IF($G11="","",CHOOSECOLS(FILTER(HSTACK('PM Project Tracker'!B9:C21,x),x>0),2,1,3)))

UPDATE - The below formula works:

=IF($M19="","",CHOOSECOLS(FILTER(HSTACK('Quote Task Master'!A30:B39),'Quote Task Master'!A30:A39>0),1,2))

 

[Fluff]

FWIW you can simplify that like

=IF($M19="","",FILTER('Quote Task Master'!A30:B39,'Quote Task Master'!A30:A39>0))