Replace #N/A to <blanks> in INDEXMATCH function

[fluffyvampirekitten]

I would like to replace all the #N/A values as a "blank"
How to do it ?

I have these few lines of codes

Please Login or Register  to view this content.

[Pete_UK]

You want the finished formula to be this:

=IFERROR(INDEX('[PatientMerge.xls]2015'!$J1:$J10000,MATCH(C1,'[PatientMerge.xls]2015'!$J1:$J10000,0)),"")

when it appears in the first cell.

Hope this helps.

Pete

[TMS]

Same way you would in the worksheet, use IFERROR.

Please Login or Register  to view this content.

In the VBA, you will need to double up the quotes.


Regards, TMS

[fluffyvampirekitten]

OMG! That works . Thank you so much ^^ Appreciated!

[TMS]

You're welcome.

[TMS]

@john55: Thanks for the rep.