Thread: Iserror - can it return a "blank" value?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
smartgal smartgal is offline
external usenet poster
  
Posts: 84
Default Iserror - can it return a "blank" value?
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?
Reply With QuoteReply With Quote