From a big list of address enter in single stroke. Excel magic and tricks
Explanation:
=VLOOKUP($A$6,'D:\[Address.xls]Address'!$B$4:$G$100,2,FALSE)
1. Vlookup - Enter Formula
2. $A$6 - Address name of person
3. 'D:\[Address.xls]Address'! - file location name and Sheet name
4. $B$4:$G$100 - Address range from address excel file
5. 2 - Addresses column number
