Thread: How can I use an IFISNUMBER formula in conjunction with Vlookup?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
  
Posts: 622
Default How can I use an IFISNUMBER formula in conjunction with Vlooku
=IF(ISNUMBER(VLOOKUP(A1,table,2,0),VLOOKUP(A1,tabl e,2,0),0)

or

=IF(ISERROR(VLOOKUP(A1,table,2,0),0,VLOOKUP(A1,tab le,2,0))
Reply With QuoteReply With Quote