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

Microsoft Excel Formula: Small

You can find small number from a big list of Rows and columns. Just Follow video procedure.

Microsoft Office: Small Formula - Watch the top videos of the week here

You can give your suggestions for developing blog.