Thread: Formula Error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
roxiemayfield roxiemayfield is offline
external usenet poster
  
Posts: 21
Default Formula Error
I have the following formula with an error. I am trying to get an na to be a
-0- if the lookup is 0.

=IF(ISNA((VLOOKUP($B13,pmp3w1,3,0)),0,VLOOKUP($B13 ,pmp3w1,3,FALSE)
Reply With QuoteReply With Quote