Thread: Return a text string when the result of VLOOKUP formula is #N/A
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jeremy nickels jeremy nickels is offline
external usenet poster
  
Posts: 13
Default Return a text string when the result of VLOOKUP formula is #N/A
Is there any way to have the result of a VLOOKUP formula be the text string
"NO" instead of #N/A when it doesn't find a match?

I'm playing around with an IF statement and the ERROR.TYPE function, but I'm
not quite getting it.
Reply With QuoteReply With Quote