changing the INDEX function so it looks in 2 ranges

[elcalvo]

in one sheet I have changed this formula:

B4: =TRANSPOSE(SORT(UNIQUE(BaseData[Partner])))
which returned 6 values in B4:G4

into:

B4: =INDEX(SORT(UNIQUE(BaseData[Partner])),SEQUENCE(2,3,1,1))
which returns 6 values in B4:D5

in another sheet I have the formula:

=XLOOKUP([@Partner], INDEX(' FILTER'!$B$4#,,), INDEX(' FILTER'!$B$5:$G$5,,))

where I want to change: INDEX(' FILTER'!$B$5:$G$5,,) so it looks in the range: B3:D3 and B6:D6

the formula should return TRUE or FALSE if the Partner was found in B3:D3 or B6:D6

 

[elcalvo]

Sorry, I see my post was somehow blunt.

I'd appreciate support for this issue and copied some screenshots in to clarify:

To Do.xlsm
	B	C	D
2	Partner
3
4	A	B	C
5	D	E	F
6
🔽 FILTER

Cell Formulas
Range	Formula
B4:D5	B4	=INDEX(SORT(UNIQUE(BaseData[Partner])),SEQUENCE(2,3,1,1))
Dynamic array formulas.

To Do.xlsm
	M
5	Include Partner
6	#REF!
CRM

Cell Formulas
Range	Formula
M6	M6	=OR(XLOOKUP([@Partner], INDEX('🔽 FILTER'!$B$4#,,), INDEX('🔽 FILTER'!$B$3#,,)) = [@Partner], XLOOKUP([@Partner], INDEX('🔽 FILTER'!$B$4#,,), INDEX('🔽 FILTER'!$B$6#,,)) = [@Partner])

Named Ranges
Name	Refers To	Cells
FromArray_1	='🔽 FILTER'!$B$4#	M6