Selected Answer
If I understand you correctly you would like to show a blank cell if the referenced cell is blank. You may like to try this formula.
[CODE=IF(ISNA(MATCH(B2,'920'!$D:$D,0)),0,IF(LEN(INDEX('920'!$C:$C,MATCH(B2,'920'!$D:$D,0))),INDEX('920'!$C:$C,MATCH(B2,'920'!$D:$D,0)),"No name"))[/CODE]
It will return "no match" if no match was found for B2 and "no name" if the match was found but there is nothing in that cell. You can repalce either placeholder with a simple "" to have a blank cell in any event.
As an alternative you might like to use the next formula which I tested in D3 of your worksheet.
=IF(C3=0,"no match", IF(INDEX('920'!$C:$C,MATCH(B3,'920'!$D:$D,0))="","no name", INDEX('920'!$C:$C,MATCH(B3,'920'!$D:$D,0))))
This formula Dispenses with the ISNA function. Instead, it relies on the result of the ISNA function in column C. Otherwise it is the same as the first solution except that the first solution looks for a string of zero length whereas the second insists on "". These are two ways of testing for the same thing with identical results.