1

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

Dharman
  • 30,962
  • 25
  • 85
  • 135

1 Answers1

0

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)))
player0
  • 124,011
  • 12
  • 67
  • 124