IF MATCH SHOW RESULT IF NOT ""-CodePudding

Hi everyone I'm trying to do a Match for values in a column there is a name and then the corresponding ID, in a part I have the list only for ID so I have to match the name, and I'm using this formula:

=INDEX(MATCH!$A$2:$A$400,MATCH(B2,MATCH!$B$2:$B$400,0))

But with empty values (this is a dynamic document) Show me #N/A so I would like something like THIS

=IF(VALUE=VALUE EXISTS, SHOW VALUE, "")

Help please!

CodePudding user response：

you can wrap it into IFNA formula and not define it:

=INDEX(IFNA(MATCH!$A$2:$A$400,MATCH(B2,MATCH!$B$2:$B$400,0)))