Thread: VLookUp
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BuffySlay BuffySlay is offline
external usenet poster
 
Posts: 3
Default VLookUp


=IF(ISNA(YourVlookupFormula),0,YourVlookupFormula)

yes, you would put your formula in twice:

the "if" statement works like this

If (COMPARISON) ,(if its TRUE do this), (if its FALSE do this)

you could do =if (your lookup = 0, "", your lookup)