Thread: remove the #n/a and make it 0
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Armando[_2_] Armando[_2_] is offline
external usenet poster
  
Posts: 6
Default remove the #n/a and make it 0
On May 13, 7:22*am, mahmoud moustafa <mahmoud
wrote:
Hi
How do i remove the #n/a and make it 0

Try this one:
=IF(COUNTIF(B$2:B$7,B23),VLOOKUP(B23,B$2:D$7,2,0), "")
Reply With QuoteReply With Quote