Spreadsheet: 161815d1339634258-vlookups-with-multiple-values-for-same-id-vlookups-example
Sheet: Sheet1

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