I would like to replace all the #N/A values as a "blank"
How to do it ?
I have these few lines of codes
'Vlookup/IndexMatch Active Ext ID Range("S2:S" & MaxRowNum).Formula = "=INDEX('[PatientMerge.xls]2015'!$J1:$J10000,MATCH(C1:C10000,'[PatientMerge.xls]2015'!$J1:$J10000,0))" 'Vlookup/IndexMatch Inactive Ext ID Range("T2:T" & MaxRowNum).Formula = "=INDEX('[PatientMerge.xls]2015'!$K1:$K10000,MATCH(C1:C10000,'[PatientMerge.xls]2015'!$K1:$K10000,0))"
Bookmarks