Thread: VLOOKUP #N/A result
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stephane Quenson Stephane Quenson is offline
external usenet poster
  
Posts: 53
Default VLOOKUP #N/A result
You have to test the result of the VLOOKUP first with the ISNA function, then
decide what to do. Example:
=IF(ISNA(VLOOKUP(6,E14:F18,2,0)), "Not Found", VLOOKUP(6,E14:F18,2,0))

Reply With QuoteReply With Quote