So i'm trying to get the formula below to show blanks instead of #N/A and REFS and for the life of me it keeps saying I'm missing parenthesis or there's not enough arguments. Can someone please point out the obvious for me?
=INDEX('[AFP Template Proposition.xlsx]Data'!$W$2:$W$2912, MATCH(1, INDEX((B162='[AFP Template Proposition.xlsx]Data'!$B$2:$B$2912) * ($K$4='[AFP Template Proposition.xlsx]Data'!$R$2:$R$2912), 0, 1), 0))
So I'm hoping where it says Column K it will show as a 1 or blank and I have to apply the logic to the subsequent columns
Bookmarks