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 02, 2022
Hi ligg_1

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

https://support.microsoft.com/en-us/office/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a: default value for 3rd optional arg. (match_type) is 1
https://support.microsoft.com/en-us/office/xmatch-function-d966da31-7a6b-4a13-a1c6-5a33ed6a0312: 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

Riny_van_Eekelen

Platinum Contributor

Feb 02, 2022

ligg_1 Replicated your model in something similar and the formulae should work. The only time I can get a zero in the first column but the others filled correctly is when the column name is not the same. So, are you sure that the "Stakeholder Name" is exactly the same in both places? No trailing spaces in one of them by any chance?

ligg_1
Copper Contributor
Feb 02, 2022
I copy and pasted the cell to ensure nothing was different and it still was pushing out "0". The solution by L z. worked when I added "0" to the match function.

Thanks for your help!

Forum Discussion

Filter Function Only Showing Chosen Columns using Match

Resources