I am using this below formula to look up a patient medical record number, and then return the value of a cell for a certain parameter (Blood pressure, heart rate, ect).
=INDEX('Required Patient Info'!C4:C1101,MATCH(C3,'Required Patient Info'!B4:B1101,0))
This code returns blank cells as a 0 instead of returning as blank. Is there a way to fix this, so that it returns just a blank value?
Bookmarks