If referenced cell is blank, display nothing

[avidcat]

I put together this formula:
=IF(ISNA(VLOOKUP(A3,Sheet2!$A$2:$E$100,5,0)),"7",VLOOKUP(A3,Sheet2!$A$2:$E$100,5,0))

If the Referenced cell A3 is blank, I want to have the cell show nothing.

I appreciate any help in editing this formula.

Thanks,
Nick

 

[Shrikant]

This might do the thing.

=IF(ISBLANK(A3),"",your formula here)

 

[Aladin Akyurek]

@avidcat

Why do you quote 7 in the formula?

 

[avidcat]

This might do the thing.

=IF(ISBLANK(A3),"",your formula here)

Thanks that worked perfect.

 

[avidcat]

Oh the "7" needs to be returned if they are not on the list as a default. Basically I have assigned a number of days to each person on a list, and if they are not on the list they default at 7 days.

 

[Aladin Akyurek]

Oh the "7" needs to be returned if they are not on the list as a default. Basically I have assigned a number of days to each person on a list, and if they are not on the list they default at 7 days.

Quotes make 7 a text value that calculations will ignore. Remove quotes in order to keep it as true number.