Forum Discussion
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 {}
Updated formula with MATCH showing 0 in the "Stakeholder Name" Column
Source table referenced
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
6 Replies
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?
- 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!
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
- I'll (or someone else) be glad to have a look to your SORTBY follow up question but please do 2 things if you don't mind:
- Open a separate discussion
- Attach your workbook (remove sensitive data if any) to this new discussion as it very very difficult to work with pictures only given the length of your formula
Thanks
