Excel VLookup Data Manipulation

This is something i learnt in excel today. Its quite handy. It similar to a Advanced Filter for unique records but can be performed on more than 1 column

I used it to help filter a massive DUMPACL output. I wanted to know unique AD group names along with the starting path structure. I didnt care after that what folders that group had permissions.

eg.

AD-Group1 C:\folder1
AD-Group1 C:\folder1\folder2
AD-Group1 C:\folder1\folder2\folder3
AD-Group2 D:\dirz
AD-Group2 D:\Dirz\folder1

I wanted the output to be

AD-Group1 C:\folder1
AD-Group2 D:\dirz

To achive this i used this formula

=VLOOKUP(AD-Group1,A1:B100,2,FALSE)

This searched for AD-Group1 between A1 and B100 cells and returned me the result from Column 2 (B), The FALSE means not an exact match

Full details on this command syntax are on :
http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx