formula returns value even when reference cell is blank

Hello again to you all. OK so this time I have run into a real problem. If you open up this workbook and click on the "Vitals Log" tab along the bottom you will see the table that troubles me. In column "G" you will see I am trying to return room numbers associated with the patient name in the corresponding cell of column "F". Starting at line 19 the formula begins to return the corresponding room number to the first blank cell on the "master census sheet", which is 834. It is literally only doing what I told it too however I would like it to not populate anything if the corresponding cell in column F is blank. I believe I need to use "ifblank", but I already have "iferror" on the formula, and I want that error trap to stay. Is there a way to rewrite that formula so that it continues to return accurate room numbers when there is a name in column F, but does nothing when that cell is blank?

Redwood Census VII desensitized.xlsm

Thank you in advance for your time and consideration,

Arlo

I am certain that will work as well. I use that in my conditional formatting...not sure why I did not think of it. Here is the problem, though. I do not know where to put that little blurb...I have tried several places, but Excel gets mad at me every time I place it. Can you help me a bit more and tell me where =f8="","" goes in this formula?

=IFERROR(INDEX('Master Census Sheet'!$A$2:$A$23,MATCH(F8,'Master Census Sheet'!$D$2:D23,0),1)," ")

I was certain one of these would work...apparently I cannot trust my own certainty.

=if(f8="",""(IFERROR(INDEX('Master Census Sheet'!$A$2:$A$23,MATCH(F8,'Master Census Sheet'!$D$2:D23,0),1)," ")))
if($f$8=" "(IFERROR(INDEX('Master Census Sheet'!$A$2:$A$23,MATCH(F8,'Master Census Sheet'!$D$2:D23,0),1)," ")," ")

I am still waiting for the Excel gods to bless me with the knowledge you guys have. Thank you so much!