Hi,
I have a weird situation where things display inconsistently in my workbook - the same code does what I want in 1 sheet but not in another.
I'm using this code to look up a patient name from the "Demographics and Contact Info" sheet based on the ID number in column A of that sheet, to autopopulate the name into the "Treatment Info" sheet when the ID number is entered in column A of that sheet:
=IF(ISNA(VLOOKUP('Treatment Info'!A6,'Demographics and Contact Info'!$A$5:$B$686,2,FALSE)),"",VLOOKUP('Treatment Info'!A6,'Demographics and Contact Info'!$A$5:$B$686,2,0))
This formula results in a cell that reads "0" if someone enters an ID # in "Treatment Info" that did not have names entered in the "Demographics and Contact Info" sheet. I want it to display a blank cell and not a 0. HOWEVER, I use an identical formula (only with sheet name changed) in a third sheet called "Navigation Record" that correctly just displays blank cells instead of 0 in this same scenario of finding a null result:
=IF(ISNA(VLOOKUP('Navigation Record'!A6,'Demographics and Contact Info'!$A$5:$B$686,2,FALSE)),"",VLOOKUP('Navigation Record'!A6,'Demographics and Contact Info'!$A$5:$B$686,2,0))
What can I do to fix the display for "Treatment Info" to blank? Why is there a discrepancy in how the same formula is working? In both sheets, the set of cells are "General" format. I even tried format painting from Navigation Record (with the desired output display) to Treatment Info to fix it but it doesn't work.
Thanks in advance!!
Bookmarks