Thread: VLOOKUP #NA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tufail Tufail is offline
external usenet poster
 
Posts: 168
Default VLOOKUP #NA

hello,
i am using vlookup formula but when cell is empty #na error is coming out is
there any other way ?

=IF(A100="","",VLOOKUP(A100,spl,12,))

thanks in advance.