View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steved[_3_] Steved[_3_] is offline
external usenet poster
 
Posts: 76
Default Can this formula be used in VBA

Hello from Steved

Can the below formula be adapted to be put in VBA

=IF(ISNA(VLOOKUP(D6,'Audit Team'!
$A$2:$F$2000,6,0)),"",VLOOKUP(D6,'Audit Team'!
$A$2:$F$2000,6,0))

Thanks for your response.