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
Bookmarks