Spreadsheet: 110032d1306837153-vlookup-error-sold-items
Sheet: Price List

Item No. | Item Name | Cost Price
6291023110041 | Dehn [NAME] =130.00 AED | 97.5
6291023110058 | Dehn Oud [NAME] Gm= 10.00 AED | 7.5
6291023110089 | [NAME] | 71.25
6291023110102 | Dehn Oud Old [NAME]   - 1 Gm = 50.00 AED | 37.5
6291023110171 | Dehn Oud [NAME]   [NAME] = 160.0 AED | 120
6291023110188 | Dehn Oud [NAME] = 80..00 AED | 60
6291023170274 | Oud [NAME] 1 | 67.5
6291023170533 | Oud [NAME] | 112.5
6291023700228 | Oud [NAME] Al Malaky | 97.5
6391068742938 | Dehn Oud [NAME] -2010 | 375
6391068742945 | Dehn Oud Burmese Old -2010 | 360
6391068742952 | Dehn Oud Malaysian -2010 | 307.5
6391068742969 | Oud Moattar from [NAME] Oud | 45
6391068743409 | Dehn Oud [NAME] [NAME] | 75
629102310217 | [NAME] | 37.5
6291023120057 | Lotion Fazza | 37.5
6291023120064 | Lotion Sheikha | 37.5
6291023120088 | Lotion Love Story | 37.5
6291023120095 | [NAME] | 37.5
6291023120101 | [NAME] | 37.5
6291023120170 | [NAME] | 37.5
6291023120200 | [NAME] | 37.5
6291023120224 | [NAME] | 30
6291023120231 | [NAME] battash | 30
639106874265 | Dukhon [NAME] | 101.25
6291023130018 | Dukhon Khass | 75
6291023130025 | [NAME] | 75
6291023130032 | Dukhon [NAME] | 75
6291023130056 | Dukhon Sheikh [NAME] | 101.25
6291023130063 | Dukhon Sheikha | 112.5
6291023130087 | Dukhon Fazza | 75
6291023130094 | Dukhon Love Story | 75
6291023130100 | Dukhon Fakr Al Ajial | 120
6291023130117 | Dukhon [NAME] 1 | 75
6291023130124 | Dukhon Rooh Fazza Al Battash | 90
6291023130131 | Dukhon Bint Al Khaleej | 112.5
6291023130179 | Dukhon [NAME] Limited Edition | 60
6291023130186 | Dukhon [NAME] | 112.5
6291023300435 | [NAME] | 150
6291023300442 | Dukhoon Magic | 97.5
6291023300466 | [NAME] | 120
6291023300497 | [NAME] | 135
6291023700235 | [NAME] | 112.5
6291023700273 | Dukhon Sirra Ala Arrimal | 75
6291023700297 | Dukhon Alf Zahra | 52.5
6291023150061 | Air [NAME] | 18.75
6291023150078 | Air Freshener Sheikh [NAME] | 26.25
6291023150085 | Air Freshener Sheikha | 30
6291023150092 | Air Freshener [NAME] | 15
6291023150108 | Air Freshener Fazza | 26.25
6291023150115 | Air [NAME] | 18.75
6291023150122 | Air Freshener Love Story | 18.75
6291023150139 | Air Freshener Ghala Zayed | 18.75
6291023150146 | Air Freshener Saqr [NAME] | 15
6291023150153 | Air [NAME] | 18.75
6291023150160 | Air Freshener Aladdin | 18.75
6291023150177 | Air [NAME] | 15
6291023150184 | Air [NAME] | 30
6291023150191 | Air Freshener Rooh Fazza [NAME] | 30
6291023150207 | Air Freshener Siraa Ala Alrrimal | 30
6291023150214 | Air [NAME] | 30
6291023150276 | [NAME] Al Ajial | 30
6291023150283 | Air Freshner Roety | 30
6291023160046 | Perfume- [NAME] | 135
6291023160107 | Perfume- Sheikh [NAME] | 52.5
6291023160176 | Perfume- Love Story | 45
6291023160183 | Perfume- [NAME] | 60
6291023160251 | Perfume- New Fazza100 ml | 60
6291023160268 | Perfume- Bint Al Khaleej | 63.75
6291023160282 | Perfume- Sheikha | 112.5
6291023160381 | Perfume- The Bride | 112.5
6291023160480 | Perfume - Rahal Al Battash | 108.75
6391068742204 | Perfume- Engage Albattash | 37.5
6391068742297 | Perfume- Roety [NAME] | 97.5
6391068742303 | [NAME] [NAME] | 90
6391068742310 | Perfume- Siraa Ala Arrimal [NAME] | 75
6391068742327 | Perfume- Fakr Al Ajial [NAME] | 82.5
6391068742532 | Perfume- New Fazza Pink 100ml | 56.25
6391068742549 | Perfume- New Fazza Woody 100ml | 63.75
6391068742587 | [NAME] Sab [NAME] | 67.5
6391068742617 | [NAME] | 150
6391068742747 | Perfume- Rooh Dubai | 127.5
6391068742754 | [NAME] Musk Dubai | 127.5
6391068742921 | Perfume- New Bin Thani - Alia Al Qamar | 105
6391068743003 | Perfume Da'edj | 60
6391068743010 | Perfume - Shbiehat El Ward | 67.5
6391068743027 | Basket - Perfumes | 71.25
6391068743041 | Perfume- Al Battash WV - Personalize | 150
6391068742679 | [NAME] | 30
6391068742686 | [NAME] | 30
6391068742693 | [NAME] | 30
6391068742709 | [NAME] [NAME] | 30
6391068742716 | [NAME] | 37.5
6391068742723 | [NAME] | 30
6391068742778 | [NAME] - The Bride | 37.5
6391068742891 | [NAME] | 45
629102311857 | Mandoos 850 | 637.5
6291023118016 | Mandos 200 | 150
6291023118023 | Mandos 300 | 225
6291023118030 | Mandos 400 | 300
6291023118047 | Mandos 500 | 375
6291023118054 | Mandoos 600 | 450
6291023118061 | Mandos 700 | 525
6291023118078 | Mandos 800 | 600
6291023118085 | Mandos 900 | 675
6291023118092 | Mandos 1000 | 750
6291023118108 | Mandos 1100 | 825
6291023118115 | Mandos 1200 | 900
6291023118122 | Mandos 1300 | 975
6291023118139 | Mandos 1400 | 1050
6291023118146 | Mandos 1500 | 1125
6291023118153 | Mandos 1600 | 1200
6291023118160 | Mandos 1700 | 1275
6291023118177 | Mandos 1800 | 1350
6291023118184 | Mandos 1900 | 1425
6291023118191 | Mandos 2000 | 1500
6291023118207 | Mandos 2100 | 1575
6291023118214 | Mandos 2200 | 1650
6291023118221 | Mandos 2300 | 1725
6291023118238 | Mandos 2400 | 1800
6291023118245 | Mandos 2500 | 1875
6291023118252 | Mandos 2600 | 1950
6291023118269 | Mandos 2700 | 2025
6291023118276 | Mandos 2800 | 2100
6291023118283 | Mandos 2900 | 2175
6291023118290 | Mandos 3000 | 2250
6291023118306 | Mandos 3100 | 2325
6291023118313 | Mandos 3200 | 2400
6291023118320 | Mandos 3300 | 2475
6291023118337 | Mandos 3400 | 2550
6291023118344 | Mandos 3500 | 2625
6291023118351 | Mandos 3600 | 2700
6291023118368 | Mandos 3700 | 2775
6291023118375 | Mandos 3800 | 2850
6291023118382 | Mandos 3900 | 2925
6291023118399 | Mandos 4000 | 3000
6291023118405 | Mandos 4100 | 3075
6291023118412 | Mandos 4200 | 3150
6291023118429 | Mandos 4300 | 3225
6291023118436 | Mandos 4400 | 3300
6291023118443 | Mandos 4500 | 1875
6291023118450 | Mandos 4600 | 3450
6291023118467 | Mandos 4700 | 3525
6291023118474 | Mandos 4800 | 3600
6291023118481 | Mandos 4900 | 3675
6291023118498 | Mandos 5000 | 3750
6291023118504 | Mandoos 1950 | 1462.5
6291023118528 | Mandoos 450 | 337.5
6291023118535 | Mandoos 250 | 187.5
6291023118542 | Mandoos 350 | 262.5
6291023118559 | Mandoos 550 | 412.5
6291023118566 | Mandoos 650 | 487.5
6291023118573 | Mandoos 750 | 562.5
6291023118580 | Mandoos 950 | 712.5
6291023118603 | Mandoos 150 | 0
6291023118610 | Mandoos 400 - 30ML | 300
6291023118658 | Mandoos - 1450 | 1087.5
6291023118665 | Mandoos - Gold | 1650
6291023118672 | Mandoos - Silver | 1500
6391068743393 | Basket - 160 | 120
6391068742792 | Fresh | 30
6391068742822 | Spicy | 37.5
6391068742839 | Woody | 22.5
6391068742846 | Flower Rose | 37.5
6391068742853 | Flower Musk | 33.75
6391068742860 | Oud Amber | 33.75
6391068742877 | Blue Oud | 0
6391068742884 | White Oud | 0
6291023110126 | Musk Fazza for Body  -1 Gm =7.50 AED | 67.5
6291023300046 | [NAME] = 5.00 AED | 3.75
6291023300053 | Mukhalat Dehn Al Oud  - 1 Gm = 7.50 AED | 5.625
6291023300060 | Mukhalat Sultan - 1 Gm = 2.50 AED | 1.875
6291023300121 | [NAME] = 5.00 AED | 3.75
6291023300138 | [NAME] 4    - 1 Gm = 2.50 AED | 1.875
6291023300152 | [NAME] = 7.50 AED | 5.625
6291023300169 | [NAME] = 5.00 AED | 3.75
6291023300176 | [NAME] = 2.50 AED | 1.875
6291023300268 | Mukhalat [NAME] = 2.50 AED | 1.875
6291023300329 | [NAME] = 7.50 AED | 5.625
6291023300381 | [NAME] 3  -  1 Gm = 3.75 | 2.8125
6291023300398 | [NAME] No.5    - 1 Gm = 2.50 AED | 1.875
6391068743416 | Tuscan Lether RDG | 15
1001000123354 | Mix Crystal (1 & 2Tola) Aed - 50)- | 37.5
6291023170540 | Wooden Oud 100,000 | 75000
6291023170557 | [NAME] 7000 | 5250
6291023500248 | Royal Diwan Products - 200 | 150
6291023520024 | [NAME] | 30
6291023520055 | [NAME] | 67.5
6291023520116 | [NAME]Special) | 150
6291023520208 | [NAME] | 6750
6291023520215 | Madkhan 1000 | 750
6291023520222 | Madkhan 1500 | 1125
6291023300541 | Mukhamriya Oud 12 Gm | 6.255
6291023300558 | Mukhamriya Zafran 12 Gm | 6.255
6291023510018 | [NAME] | 6.255
6291023510049 | [NAME] | 4.3725
6291023130070 | Promotion [NAME] | 101.25
6391068742174 | Set -Marrina Al Battash | 112.5
6391068742471 | Set Magic 3 In 1 [NAME] | 120
6391068742501 | Set Fazza | 97.5
6391068742518 | Set Zekrayat | 60
6391068742525 | Set Love Story | 90
6391068742624 | Set Sirra Al Alremal | 240
6391068742631 | Set Fakher Al Ajial | 296.25
6391068742648 | Set Fazza Collection | 187.5
6391068742655 | Set Dukhon Collection | 225
6391068742662 | Set Sheikh [NAME] | 247.5
6391068742808 | [NAME] | 236.25
6391068742815 | Set Air Freshener | 63.75
6391068742907 | Set- ALIA Al Qamar Surprise | 225
6391068742914 | [NAME] | 337.5
6391068743034 | Perfume- Al BAttash WV | 112.5
6391068743065 | [NAME] | 1500
6391068743072 | [NAME] | 712.5
6391068743324 | Set - the best Women Collection | 112.5
6391068743331 | Set - the best Men Collection | 112.5
6391068743348 | Set - the best Mukhallat Collection | 112.5
6391068743355 | Set - the best Oud Collection | 112.5
6391068743362 | Set - the best Oriental Collection | 112.5
6391068743379 | Set - the best Musk Collection | 112.5
6391068743386 | Set - the best French Line Collection | 112.5
6391068743423 | Promotion Set Western Valley 300 | 225
6391068743485 | Set - Fresh Collection | 112.5
6391068743508 | Set - Amber Collection | 112.5
6391068743522 | Set - Ghala Zayed & [NAME] | 112.5
6391068743706 | [NAME] | 300
6291023700305 | Special Orders | 30
6391068743089 | ( EM ) AW0003 - Oud Malaysia | 127.5
6391068743096 | ( EM )  AW0013 - Oud Murakki | 52.5
6391068743102 | ( EM ) AW 0015 - Oud Malaysia | 52.5
6391068743119 | ( EM ) AW 0023 - Oud Hindi ( | 112.5
6391068743126 | ( EM ) AW 0026 - Oud Murakki | 37.5
6391068743133 | (EM) D/O 0003 - Dehn Oudh Indonesia | 637.5
6391068743140 | ( EM) D/O 0014 - Dehnal Oudh Ateeque | 1200
6391068743157 | ( EM) D/O 0023 - Dehnal Oudh Hindi | 900
6391068743164 | (EM) D/O 0037 - Dehnal Oudh Combodi | 825
6391068743171 | ( EM) ELA 0021 - Mukhallat Special | 187.5
6391068743188 | (EM) ELA 0025 - Mukhallat Extra | 37.5
6391068743195 | (EM) ELA 0028 - Mukhallat Maliki | 168.75
6391068743201 | (EM) ELA 0030 - Mukhallat Ateeque | 112.5
6391068743218 | (EM) ELA 0031 - Mukhallat Khosoosi | 93.75
6391068743225 | (EM) AW 0037 - Oud Bormi | 93.75
6391068743232 | (EM) D/O 0038 - Dehnal Oudh Hindi | 675
6391068743249 | (EM) AW 0020 - Malisi | 48.75
6391068743256 | (EM) AW 0039 - Combody | 112.5
6391068743263 | (EM) AW 007 - Cambodi | 150
6391068743270 | (EM) AW 0040 -  Oud Cambodi | 225
6391068743287 | (EM) AW 0011 - Oud Malaysia Supper | 375
6391068743294 | (EM) AW 0021 - Oud Hindi | 93.75
6391068743300 | (EM) 0012 Dehnal Oudh Bormi | 1350
6391068743317 | (EM) 0018 - Dehnal Oudh Hindi Kadim | 1875
6391068743430 | (EM)New Mix Crystal (1/4 & 1/2 Tola) Aed - 40 | 30
6391068743447 | (EM) AW 0020 - Oudi Hindi | 48.75
6391068743454 | (EM) AW 0060 - Agarwood | 150
6391068743461 | (EM) ELA 0004 - Mais | 15
6391068743478 | (EM) ELA 0006 - Mukhallat | 22.5
6391068743515 | (EM)D/O  0010 - Dehnal Oud Suefi | 1050
6391068743539 | ( EM ) AW 0021 Wood Cambodi | 67.5
6391068743546 | ( EM ) AW 0042 D/O Cambodi | 450
6391068743553 | ( EM ) AW 0043 D/O Hindi | 600
6391068743607 | (EM) AW0003 - Oud Malaysia - KG | 7500
6391068743614 | (EM) AW007 - Oud Combodi - KG | 9000
6391068743621 | (EM) AW0011 - Oud [NAME] | 22500
6391068743638 | (EM) AW0013 - Oud Murraki - KG | 2850
6391068743645 | (EM) AW0015 - Oud Malaysia - KG | 2850
6391068743652 | (EM) AW0020 - Malisi - KG | 3000
6391068743669 | (EM) AW0020 - Oud [NAME] | 3000
6391068743676 | (EM) AW0021 - Wood Combodi - KG | 4500
6391068743683 | (EM) AW0021 - Oud [NAME] | 5625
6391068743690 | (EM) AW0023 - Oud [NAME] | 6750
6391068743713 | (EM) AW0026 - Oud Murakki - KG | 2250
6391068743720 | (EM) AW0037 - Oud Bormi - KG | 5625
6391068743737 | (EM) AW0039 - Combody - KG | 6750
6391068743744 | (EM) AW0040 - Oud Combodi - KG | 13500
6391068743751 | (EM) AW0060 - Agarwood - KG | 9000
3003010000012 | (R) Oud Hindi (R) | 6
3003010000029 | (R) Oud [NAME] (R) | 7.5
3003010000036 | (R) Oud Malisia Super (R) | 26.25
3003010000043 | (R) Oud Indonasi (R) | 2.625
3003010000050 | (R) Oud Bormi (R) | 18.75
3003010000067 | (R) Dehn [NAME] (R) | 3
3003010000074 | (R) [NAME] (R) | 3.75
3003010000081 | (R) Wared [NAME] (R) | 3.75
3003010000098 | (R) Wared [NAME] (R) | 75
3003010000104 | (R) [NAME] (R) | 5.25
3003010000111 | (R) [NAME] (R) | 11.25
3003010000128 | (R) Mukhalat Al Dhabi (R) | 11.25
3003010000135 | (R) [NAME] (R) | 7.5
3003010000142 | (R) [NAME] (R) | 7.5
3003010000159 | (R) Mukhalat Amiri (R) | 7.5
3003010000166 | (R) [NAME] (R) | 7.5
3003010000173 | (R) [NAME] (R) | 11.25
3003010000180 | (R) [NAME] (R) | 11.25
3003010000197 | (R) [NAME] (R) | 7.5
3003010000203 | (R) [NAME] (R) | 11.25
3003010000227 | (R) Dehn Oud [NAME] (R) | 52.5
3003010000234 | (R) Dehn Oud [NAME] (R) | 86.25
3003010000241 | (R) Dehn [NAME] (R) | 101.25
3003010000258 | (R) [NAME] (R) | 37.5
3003010000272 | (R) Dehn Oud [NAME] (R) | 7.5
3003010000296 | (R) Oud Arian (R) | 7.5
3003010000302 | (R) Oud Black -A-(R) | 1.125
3003010000319 | (R) Oud Black -B-(R) | 1.125
3003010000326 | (R) Oud Black -C-(R) | 1.125
3003010000333 | (R) Oud Black -D-(R) | 1.5
3003010000340 | (R) Oud Black -E-(R) | 1.125
3003010000357 | (R) Oud Malisia 29 (R) | 7.5
3003010000364 | (R) Oud [NAME] 30 (R) | 7.5
3003010000371 | (R) Oud Hindi -32-(R) | 6
3003010000388 | (R) [NAME] (R) | 2.25
3003010000395 | (R) White Patehuli  ( R ) | 2.25
3003010000401 | (R) Attar Dubai (R) | 2.25
3003010000418 | (R) Fakher Al Arab (R) | 2.25
3003010000425 | (R) [NAME] ( R ) | 2.25
3003010000432 | (R) Mamzar Oil (R) | 2.25
3003010000449 | (R) Sadaf  (R) | 2.25
3003010000456 | (R) Gold Bottle 1/4 Tola +1 Tola (R) | 9
3003010000500 | (R) R ( 110 ) | 82.5
3003010000517 | (R) R ( 60) | 45
3003010000524 | (R) R (220) | 165
3003010000531 | (R) R ( 240) | 180
3003010000548 | (R) R ( 220 ) | 165
3003010000555 | (R) R ( 300) | 225
3003010000562 | (R) R ( 60 ) | 45
3003010000579 | (R) R ( 40 ) | 30
3003010000586 | (R) R ( 30 ) | 22.5
3003010000593 | (R) R ( 25 ) | 18.75
3003010000609 | (R) R ( 20 ) | 15
3003010000616 | (R) R ( 15 ) | 11.25
3003010000623 | (R) R ( 140 ) | 105
3003010000630 | (R) R ( 120 ) | 90
3003010000647 | (R) R ( 100) | 75
3003010000654 | (R) R ( 360 ) | 270
3003010000661 | (R) R ( 1900) | 1425
3003010000678 | (R) R ( 250 ) | 187.5
3003010000685 | (R) R ( 290 ) | 217.5
3003010000692 | (R) R 1028 ( 270) | 202.5
3003010000708 | (R) R (230) | 202.5
3003010000715 | (R) R (230) | 172.5
3003010000722 | (R) R ( 170 ) | 127.5
3003010000739 | (R) R ( 170) | 127.5
3003010000746 | (R) R ( 560 ) | 420
3003010000753 | (R) R (280) | 210
3003010000760 | (R) R ( 400) | 300
3003010000777 | (R) R ( 120 ) | 90
3003010000784 | (R) R ( 70) | 52.5
3003010000791 | (R) R ( 200) | 150
3003010000807 | (R) R ( 300) | 225
6391068742594 | [NAME] 200 AED | 0
6391068742600 | [NAME] 300 AED | 0
6391068743973 | [NAME] from Royal Diwan Group | 0.75
3000001000013 | Soap Rooh Fazza 250 gms [NAME] | 0
3000001000020 | Soap Magic 250gms [NAME] | 0
3000001000037 | Soap Marina 250gms [NAME] | 0
3000001000044 | Soap Marina 85gms [NAME] | 0
3000001000051 | Soap Magic 85 gms [NAME] | 0
3000001000068 | Soap Rooh Fazza 85gms [NAME] | 0
3000001000075 | Soap Fazza 250 gms [NAME] | 0
3000001000082 | Soap Roety 250 gms [NAME] | 0
3000001000099 | Soap Roety 85 gms [NAME] | 0
3000001000105 | Soap Fazza 85 gms [NAME] | 0
2991001001005 | WV -Silver Bar | 112.5
2991001001012 | WV- Carnival | 112.5
2991001001036 | WV -Garnet Stone | 112.5
2991001001043 | WV -Marble Shade | 112.5
2991001001050 | WV - Arabesque | 112.5
2991001001067 | WV - Asbestos | 112.5
2991001001074 | WV - Glamorous | 112.5
2991001001081 | WV - Gondola Rose | 112.5
2991001001098 | WV - Mulan Rouge | 112.5
2991001001104 | Amytis 60 Ml | 750
2991001001111 | Nabucco 60 Ml | 750
2991001001197 | WV Concentrated Perfume Oil  Silent Dare | 82.5
2991001001203 | WV Concentrated Perfume Oil   Lilly Lass | 82.5
2991001001210 | Wv- Shrewd | 112.5
2991001001227 | WV Concentrated Perfume Oil Azure | 82.5
2991001001234 | WV Concentrated Perfume Oil  Ogle | 82.5
2991001001258 | Wv - Silence Dare | 112.5
2991001001265 | WV - Vistal | 112.5
2991001001272 | WV - Ogle | 112.5
2991001001289 | WV - Clamour | 112.5
2991001001296 | WV -Lily [NAME] | 112.5
2991001001319 | WV - Azure | 112.5
2991001001340 | WV Concentrated Oil - Clamour | 82.5
2991001001364 | WV - Tuscan Lady | 112.5
2991001001401 | Red & Black - Nautical Star | 187.5
2991001001418 | Red & Black - Wind Rose | 187.5
2991001001425 | Red & Black -  Pure Devotion | 187.5
2991001001432 | Red & Black - Destiny | 187.5