Return a Blank instead of #N/A and/or 0 with INDEX/MATCH

[richtks]

Trying to return a blank instead of a #N/A or 0 with INDEX and MATCH. Formula Below...

=INDEX(Data[GC],MATCH([Product Key],Data[Product Code],0))


Thanks in advance for your assistance and time.

Regards

Richard T.

 

[Fluff]

Glad we could help & thanks for the feedback