samedi 18 novembre 2017

INDEX MATCH MATCH, Return "0"

=INDEX(WA,MATCH("Sales Commissions",WA[Column1],0),MATCH(S12,WA[#Headers],0))

Returns #N/A

I would like it to return 0

I have attempted nested "IFERROR" and nested "IF(ISNA" but seem to be missing something

appreciate any direction.

thanks!

Aucun commentaire:

Enregistrer un commentaire