Forum Discussion

Copper Contributor

Feb 01, 2022

Solved

Filter Function Only Showing Chosen Columns using Match

Hello - I am trying to replace the column numbers in the {} with a match function referencing the headers from the source table but the formula is spitting out 0. Initial formula with {} ...

excel

Formulas and Functions

Lorenzo
Feb 01, 2022
Hi ligg_1

Could you try any of the following:
=MATCH(N8:Q8,StakeholderCommPlan[#Headers],0)
or
=XMATCH(N8:Q8,StakeholderCommPlan[#Headers])

MATCH: default value for 3rd optional arg. (match_type) is 1
XMATCH: default value for 3rd optional arg. (match_mode) is 0

If none of the above fix the issue please attach a sample workbook to your next reply - Thanks

Lorenzo

Silver Contributor

Feb 01, 2022

Hi ligg_1

Could you try any of the following:

=MATCH(N8:Q8,StakeholderCommPlan[#Headers],0)

=XMATCH(N8:Q8,StakeholderCommPlan[#Headers])

MATCH: default value for 3rd optional arg. (match_type) is 1

XMATCH: default value for 3rd optional arg. (match_mode) is 0

If none of the above fix the issue please attach a sample workbook to your next reply - Thanks

ligg_1

Copper Contributor

Feb 02, 2022

Lorenzo

Thanks! The first option worked!

Do you know if it is possible to use the SORTBY function here to sort by "next communication date" and then "next communication responsible party" (or at a minimum "next communication date")? I am not able to figure this out.