Trying to display blank cells as blank, rather than 0% with INDEX and MATCH

Hi,

Trying to pull through %'s from a contacts tab to then display the average however, blank cells are pulling through as 0% rather than remaining blank:

=IFNA(INDEX(Contacts[%],MATCH([@[Contact Name]],Contacts[Contact Name],0)),"")

I'm not familiar with the IF(ISBLANK function etc.

Any ideas?

Thnaks

The basic construct would be:

=IF(return_value = "","", return_value)

where return_value is your formula, so it would become:

=IFERROR(IF(INDEX(Contacts[%],MATCH([@[Contact Name]],Contacts[Contact Name],0))="","",INDEX(Contacts[%],MATCH([@[Contact Name]],Contacts[Contact Name],0))),"")

Hope this helps.

Pete

Much appreciated both, worked a treat. Rep added!