fishmarket

To add the key thing is that there is slight difference in date of joining between the two dates. Else a three way lookup could have been easily done using Index and Match function.