for(i in 1:dim(newdata)[1])
{
   for(j in 1:dim(newdata1)[1])
{
    if(newdata$`Tab No`[i]==newdata1$`Tab No`[j] & (newdata$`Survey Date`[i]
>= newdata1$`Survey Start Date`[j] & newdata$`Survey Date`[i]
<=newdata1$`Survey End Date`[j]))
{
 newdata$`Village Name`[i] <- newdata1$`Village Name`[j]
}
}}