Thursday, December 30, 2010

Excel Formula Address from Vlookup magic

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