Spreadsheet: 59448d1259940781-vlookup-to-return-multiple-cells-of-same-lookup-value-test-1-
Sheet: Art log

 |  | Artist Log
 |  | Gallery | 0.45
 |  | Artist | 0.55
client  ref | Our Artist Ref | Invoice No. | Date | Artist ref | Artist | Description | Artist price | Our Premium | Sale Amount | SOLD | Date of  Sale | Deposit | Owed | [NAME] | Delivery Method | Delivery  cost | Artist  Profit | Gallery Profit | Date  returned
 | A0006 | AR0055 | 2009-12-01 00:00:00 | F1 | Elaine | bulbs - oil on canvas (150x110 cm) | 6000 |  | 6000 |  |  |  |  |  |  |  | 0 | 0
 | A0006 | AR0056 | 2009-12-01 00:00:00 | F2 | Elaine | [NAME] on canvas (130x100 cm) | 4000 |  | 4000 |  |  |  |  |  |  |  | 0 | 0
 | A0006 | AR0057 | 2009-12-01 00:00:00 | F3 | Elaine | new spring - oil on canvas (130x110 cm) |  |  | 0 |  |  |  |  |  |  |  | 0 | 0
 | A0006 | AR0058 | 2009-12-01 00:00:00 | F4 | Elaine | turkey - oil on canvas (130x110 cm) |  |  | 0 |  |  |  |  |  |  |  | 0 | 0
 | A0006 | AR0059 | 2009-12-01 00:00:00 | F5 | Elaine | boris - monkey (130x100cm) |  |  | 0 |  |  |  |  |  |  |  | 0 | 0
 | A0007 | AR0060 | 2009-12-01 00:00:00 | F6 | Stuart | Fllying Fish, The Cable St Conundrum 152 x 122 cm | 6000 |  | 6000 |  |  |  |  |  |  |  | 0 | 0
 | A0007 | AR0061 | 2009-12-01 00:00:00 | F7 | Stuart | Do at The Haymarket Hotel 152 x 122 cm | 6000 |  | 6000 |  |  |  |  |  |  |  | 0 | 0
 | A0007 | AR0062 | 2009-12-01 00:00:00 | F8 | Stuart | [NAME] outside Bank of England 152 x 122 cm | 6000 |  | 6000 |  |  |  |  |  |  |  | 0 | 0
 | A0007 | AR0063 | 2009-12-01 00:00:00 | F9 | Stuart | Fetish [NAME] at Aberdeen Centre 122 x 152 cm | 6000 |  | 6000 |  |  |  |  |  |  |  | 0 | 0
 | A0007 | AR0064 | 2009-12-01 00:00:00 | [NAME] | Stuart | [NAME] landscape | 140 |  | 140 | 140 |  |  |  |  |  |  | 77 | 63
 | A0007 | AR0065 | 2009-12-01 00:00:00 | F11 | Stuart | A Man Named [NAME] landscape | 120 |  | 120 | 120 |  |  |  |  |  |  | 66 | 54
 | A0007 | AR0066 | 2009-12-01 00:00:00 | F12 | Stuart | Man Who Laughs A1 portrait | 140 |  | 140 |  |  |  |  |  |  |  | 0 | 0
 | A0007 | AR0067 | 2009-12-01 00:00:00 | F13 | Stuart | The Caterpillar A2 landscape | 120 |  | 120 |  |  |  |  |  |  |  | 0 | 0
 | A0007 | AR0068 | 2009-12-01 00:00:00 | F14 | Stuart | Alice in Wonderland Illustrated book | 65 |  | 65
 | A0007 | AR0069 | 2009-12-01 00:00:00 | F15 | Stuart | I Want Someone to Buy Me a Pony 30 x 30 cm | 275 |  | 275
 | A0008 | AR0070 | 2009-12-01 00:00:00 | F16 | [NAME] | Internal Combustion 30 x 35 cm | 275 |  | 275
 | A0008 | AR0071 | 2009-12-01 00:00:00 | F17 | [NAME] | Are You The One Who Locked My Ancestors in a Cage? 30 x 35 cm | 275 |  | 275
 | A0008 | AR0072 | 2009-12-01 00:00:00 | F18 | [NAME] | The Ambassadors Reception 76 x 51 cm | 395 |  | 395
 | A0008 | AR0073 | 2009-12-01 00:00:00 | F19 | [NAME] | Coming To America 91 x 61 cm | 4500 |  | 4500
 | A0008 | AR0074 | 2009-12-01 00:00:00 | F20 | [NAME] | Against the Image of Bosch 102 x 102 cm | 8950 |  | 8950
 | A0008 | AR0075 | 2009-12-01 00:00:00 | F21 | [NAME] | Brothers 60 x 120 cm | 3950 |  | 3950
 | A0008 | AR0076 | 2009-12-01 00:00:00 | F22 | [NAME] | Hoover Girl 61 x 61 cm | 2900 |  | 2900
 | A0008 | AR0077 | 2009-12-01 00:00:00 | F23 | [NAME] | Dark Study Portrait 61 x 71 cm | 3250 |  | 3250
 | A0008 | AR0078 | 2009-12-01 00:00:00 | F24 | [NAME] | Renaissance Man 107 x 66 cm | 4700 |  | 4700
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 64055 | 0 | 64055 |  |  |  |  |  |  |  |  | 117
 |  |  |  |  |  | Samurai charge    £150