Thread: Help Vlook up returning N?A
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
andy[_2_] andy[_2_] is offline
external usenet poster
  
Posts: 4
Default Help Vlook up returning N?A
We are using the following formula and it returns N/A
=IF($A790,IF(VLOOKUP($A79,'BO
Output'!$A$3:$P$2002,4,FALSE)="","",VLOOKUP($A79,' BO
Output'!$A$3:$P$2002,4,FALSE)),"")

How do i use isna function with this formula
--
andy
Reply With QuoteReply With Quote