View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default If Vlookup is error ( #NA)

I have this formula
=IF(VLOOKUP(RU!C3,data!$E$3:$R$16,2,FALSE)0,(VLOO KUP(RU!C3,data!$E$3:$R$16,2,FALSE)),"")

that is producing #NA if it doesn't find C3. I would instead like the result
to be blank "" when it produces an #NA


Thanks,

Steve