Spreadsheet: 162790d1340066205-vlookups-with-multiple-values-for-same-id-daniel1986_extracting_dependent_uniques_18jun12_01
Sheet: Sheet1

1 | 2 | 3 | 4 |  | Department | Value
Department | Value of Sale | Date | Branch |  | Wine
Commodities | 10 | 2012-06-02 00:00:00 | [NAME] |  | Commodities
Commodities | 10 | 2012-06-02 00:00:00 | [NAME] ([NAME]) |  | Real Estate
Commodities | 10 | 2012-06-02 00:00:00 | [NAME] ([NAME])
Commodities | 10 | 2012-06-02 00:00:00 | [NAME] ([NAME]) |  | Wine | Commodities | Real Estate
Commodities | 10 | 2012-06-03 00:00:00 | [NAME]
Commodities | 10 | 2012-06-03 00:00:00 | [NAME]
Commodities | 10 | 2012-06-04 00:00:00 | [NAME] ([NAME])
Commodities | 10 | 2012-06-05 00:00:00 | [NAME] ([NAME])
Commodities | 10 | 2012-06-05 00:00:00 | [NAME] ([NAME])
Commodities | 10 | 2012-06-05 00:00:00 | [NAME]
Commodities | 10 | 2012-06-06 00:00:00 | [NAME] ([NAME])
Commodities | 20 | 2012-06-06 00:00:00 | [NAME]
Commodities | 40 | 2012-06-02 00:00:00 | [NAME]
Commodities | 40 | 2012-06-02 00:00:00 | [NAME]
Commodities | 40 | 2012-06-03 00:00:00 | [NAME]
Commodities | 40 | 2012-06-05 00:00:00 | [NAME]
Commodities | 60 | 2012-06-02 00:00:00 | [NAME] ([NAME])
Commodities | 60 | 2012-06-04 00:00:00 | [NAME] ([NAME])
Commodities | 60 | 2012-06-06 00:00:00 | [NAME]
Commodities | 80 | 2012-06-04 00:00:00 | [NAME]
Commodities | 80 | 2012-06-05 00:00:00 | [NAME] ([NAME])
Commodities | 100 | 2012-06-06 00:00:00 | [NAME] ([NAME])
Real Estate | 5 | 2012-06-02 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-02 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-02 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-02 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-02 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-02 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-02 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-02 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-02 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-02 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-03 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-03 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-03 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-03 00:00:00 | [NAME] ([NAME])
Real Estate | 5 | 2012-06-04 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-04 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-04 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-04 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-04 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-04 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-04 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-04 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-04 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-05 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-05 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-06 00:00:00 | [NAME]
Real Estate | 5 | 2012-06-06 00:00:00 | [NAME]
Real Estate | 10 | 2012-06-04 00:00:00 | [NAME]
Real Estate | 10 | 2012-06-06 00:00:00 | [NAME]
Real Estate | 20 | 2012-06-03 00:00:00 | [NAME]
Real Estate | 40 | 2012-06-04 00:00:00 | [NAME]
Real Estate | 60 | 2012-06-05 00:00:00 | [NAME] ([NAME])
Wine | 1 | 2012-06-02 00:00:00 | [NAME]
Wine | 1 | 2012-06-02 00:00:00 | [NAME]
Wine | 1 | 2012-06-02 00:00:00 | [NAME]
Wine | 1 | 2012-06-02 00:00:00 | [NAME]
Wine | 1 | 2012-06-02 00:00:00 | [NAME]
Wine | 1 | 2012-06-02 00:00:00 | [NAME] ([NAME])
Wine | 1 | 2012-06-02 00:00:00 | [NAME] ([NAME])
Wine | 1 | 2012-06-02 00:00:00 | [NAME]
Wine | 1 | 2012-06-03 00:00:00 | [NAME]
Wine | 1 | 2012-06-03 00:00:00 | [NAME]
Wine | 1 | 2012-06-03 00:00:00 | [NAME]
Wine | 1 | 2012-06-03 00:00:00 | [NAME]
Wine | 1 | 2012-06-03 00:00:00 | [NAME]
Wine | 1 | 2012-06-03 00:00:00 | [NAME] ([NAME])
Wine | 1 | 2012-06-03 00:00:00 | [NAME] ([NAME])
Wine | 1 | 2012-06-03 00:00:00 | [NAME]
Wine | 1 | 2012-06-04 00:00:00 | [NAME]
Wine | 1 | 2012-06-04 00:00:00 | [NAME]
Wine | 1 | 2012-06-04 00:00:00 | [NAME]
Wine | 1 | 2012-06-04 00:00:00 | [NAME]
Wine | 1 | 2012-06-04 00:00:00 | [NAME]
Wine | 1 | 2012-06-04 00:00:00 | [NAME] ([NAME])
Wine | 1 | 2012-06-04 00:00:00 | [NAME] ([NAME])
Wine | 1 | 2012-06-06 00:00:00 | [NAME]
Wine | 1 | 2012-06-06 00:00:00 | [NAME]
Wine | 1 | 2012-06-06 00:00:00 | [NAME]
Wine | 1 | 2012-06-06 00:00:00 | [NAME]
Wine | 1 | 2012-06-06 00:00:00 | [NAME]
Wine | 1 | 2012-06-06 00:00:00 | [NAME]
Wine | 1 | 2012-06-06 00:00:00 | [NAME]
Wine | 1 | 2012-06-06 00:00:00 | [NAME]
Wine | 1 | 2012-06-06 00:00:00 | [NAME]
Wine | 2 | 2012-06-04 00:00:00 | [NAME]
Wine | 2 | 2012-06-04 00:00:00 | [NAME]
Wine | 2 | 2012-06-06 00:00:00 | [NAME] ([NAME])
Wine | 2 | 2012-06-06 00:00:00 | [NAME] ([NAME])
Wine | 2 | 2012-06-06 00:00:00 | [NAME] ([NAME])
Wine | 3 | 2012-06-02 00:00:00 | [NAME]
Wine | 3 | 2012-06-03 00:00:00 | [NAME] ([NAME])
Wine | 3 | 2012-06-04 00:00:00 | [NAME]
Wine | 3 | 2012-06-04 00:00:00 | [NAME]
Wine | 3 | 2012-06-04 00:00:00 | [NAME]
Wine | 3 | 2012-06-04 00:00:00 | [NAME]
Wine | 3 | 2012-06-04 00:00:00 | [NAME]
Wine | 3 | 2012-06-04 00:00:00 | [NAME]
Wine | 3 | 2012-06-04 00:00:00 | [NAME]
Wine | 3 | 2012-06-05 00:00:00 | [NAME]
Wine | 3 | 2012-06-05 00:00:00 | [NAME]
Wine | 3 | 2012-06-05 00:00:00 | [NAME]
Wine | 3 | 2012-06-05 00:00:00 | [NAME]
Wine | 3 | 2012-06-06 00:00:00 | [NAME] ([NAME])
Wine | 6 | 2012-06-02 00:00:00 | [NAME]
Wine | 6 | 2012-06-04 00:00:00 | [NAME]
Wine | 6 | 2012-06-05 00:00:00 | [NAME]
Wine | 6 | 2012-06-05 00:00:00 | [NAME]
Wine | 6 | 2012-06-05 00:00:00 | [NAME] ([NAME])
Wine | 6 | 2012-06-05 00:00:00 | [NAME]
Wine | 6 | 2012-06-06 00:00:00 | [NAME]
Wine | 6 | 2012-06-06 00:00:00 | [NAME] ([NAME])
Wine | 6 | 2012-06-06 00:00:00 | [NAME] ([NAME])
Wine | 8 | 2012-06-04 00:00:00 | [NAME]
Wine | 10 | 2012-06-03 00:00:00 | [NAME]
Wine | 10 | 2012-06-04 00:00:00 | [NAME] ([NAME])
Wine | 12 | 2012-06-06 00:00:00 | [NAME]
Wine | 20 | 2012-06-04 00:00:00 | [NAME] ([NAME])