Thread: Why does my formula in Excell return a #N/A?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Darrel A
 
Posts: n/a
Default Why does my formula in Excell return a #N/A?
I am using the same formula on several different worksheets. Some work and
some return #N/A as a result. Any suggestions? Here is my formula:

=IF(ISERROR(VLOOKUP((CONCATENATE($C42,"INSQUOTE-AUTO")),Pronto2!$1:$2500,8,FALSE)),"",VLOOKUP((CON CATENATE($C42,"INSQUOTE-AUTO")),Pronto2!$1:$1940,8,FALSE))
Reply With QuoteReply With Quote