View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tufail Tufail is offline
external usenet poster
 
Posts: 168
Default MULTI VLOOKUP error #N/A

Hello,
I am using this formula =VLOOKUP(B1,IF(C10,Exp2,Exp),2,) now problam is
that when cell C1 empty this error is coming out #N/A now plz tell me what
should i do for this error, i means i waon't show this error even C1 is empty.
Thanks/Tufail