Thread: simple macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ward376 ward376 is offline
external usenet poster
  
Posts: 360
Default simple macro
You could use isna in your formulas to keep the na values from
appearing:

=IF(ISNA(VLOOKUP(B1,$D$1:$E$7,2,FALSE)),"",(VLOOKU P(B1,$D$1:$E
$7,2,FALSE)))

Cliff Edwards



Reply With QuoteReply With Quote