Hi Steved
and how do you want this formula in VBA?. Just as a result in one
cell??

--
Regards
Frank Kabel
Frankfurt, Germany


Steved wrote:
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.