IF MATCH SHOW RESULT IF NOT ""

user_16239103 0
Viewed 27

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, "")

enter image description here enter image description here

nested-if google-sheets match if-statement arrays
1 Answers

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)))
user_56326290
Related