Thread: Vlookup with #N/A
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sverre sverre is offline
external usenet poster
  
Posts: 78
Default Vlookup with #N/A
How do I write a vlookup that works for n/a

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

Above one does not work

br
sverre
Reply With QuoteReply With Quote