S
smartgal
I have the following formula:
=IF(ISERROR(VLOOKUP(A5,Input!A:B,2,0)),"",VLOOKUP(A5,Input!A:B,2,0))
If I don't have an entry in my "input" sheet, it returns a value of "0."
What I *want* it to do is to not show anything if there's no entry. Can I
just make it look blank?
=IF(ISERROR(VLOOKUP(A5,Input!A:B,2,0)),"",VLOOKUP(A5,Input!A:B,2,0))
If I don't have an entry in my "input" sheet, it returns a value of "0."
What I *want* it to do is to not show anything if there's no entry. Can I
just make it look blank?