FILTER specific columns

[Sufiyan97]

I have below columns in my data

Important.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	Sr No	code	User Name	Email Address	Course Taken	Subject Area	Live/Self Study	Total Credit	Course Status	Course Assigned By Firm	Location	Designation
Sheet1

Now I just want to FILTER below columns in another sheet called Filter

Important.xlsx
	A	B	C	D	E	F
1	Location	Designation	User Name	Course Taken	Course Status	Live/Self Study
Filter

 

[Fluff]

How about

=CHOOSECOLS(Sheet1!A2:L15,XMATCH(A1:F1,Sheet1!A1:L1))

 

[Sufiyan97]

Hi Fluff,

Thank you very much, this work s perfect.

Can we use MATCH instead of XMATCH?
and
What is the benefit of using XMATCH?

 

[Fluff]

Yes you can, I just tend to use xmatch these days.