Thread: Help with a formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nate Oliver[_3_] Nate Oliver[_3_] is offline
external usenet poster
  
Posts: 71
Default Help with a formula
Hi Kimberly,

Try: =IF(ISNUMBER(MATCH(A40,A10:A29,FALSE)),0,B40)

Regards,
Nate Oliver
Reply With QuoteReply With Quote