# If error won't return blanks

1. ## If error won't return blanks

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

2. ## Re: If error won't return blanks

use IFERROR( formula , "")

=IFERROR(INDEX('https://gallagherltd-my.sharepoint.com/personal/nicky_nel_networkplus_co_uk/Documents/[AFP Template Proposition.xlsx]Data'!\$W\$2:\$W\$2912, MATCH(1, INDEX((B162='https://gallagherltd-my.sharepoint.com/personal/nicky_nel_networkplus_co_uk/Documents/[AFP Template Proposition.xlsx]Data'!\$B\$2:\$B\$2912) * (\$K\$4='https://gallagherltd-my.sharepoint.com/personal/nicky_nel_networkplus_co_uk/Documents/[AFP Template Proposition.xlsx]Data'!\$R\$2:\$R\$2912), 0, 1), 0)),"")

BUT
IFERROR worked on K162

3. ## Re: If error won't return blanks

Hi there,

Didn't realise I hadn't responded. Thank you for your help on this!

4. ## Re: If error won't return blanks

you are welcome

There are currently 1 users browsing this thread. (0 members and 1 guests)