Thread: Vlookup with #N/A
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sverre sverre is offline
external usenet poster
  
Posts: 78
Default correction-should be IF with na not vlookup
Sorry, wrong of me....

Below does not work when there is na. Can I correct it?

=IF(--F8="#N/A";1;0)

f8 is by the way a Vlookup that has catched a number.

sverre


br
sverre
Reply With QuoteReply With Quote