Thread: 0 Vlookup Value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tufail Tufail is offline
external usenet poster
 
Posts: 168
Default 0 Vlookup Value

hello
i am using following vlookup, but when there isn't lookup value then coming
out O which i don't want !

=IF($J15="","",IF(ISNA(VLOOKUP($J15,Header3,2,))," ",VLOOKUP($J15,Header3,2,)))

thanks in advance.