0% found this document useful (0 votes)
21 views5 pages

Excel Lookup Assignment

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
21 views5 pages

Excel Lookup Assignment

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Product_ID Product_Name Category Price

P001 Product_2 Clothing $ 145.68


P002 Product_3 Groceries $ 95.71
P003 Product_4 Books $ 355.19
P004 Product_5 Clothing $ 236.94
P005 Product_6 Furniture $ 421.81
P006 Product_7 Groceries $ 110.38
P007 Product_8 Groceries $ 90.83
P008 Product_9 Electronics $ 71.17
P009 Product_10 Clothing $ 363.82
P010 Product_11 Electronics $ 24.92
P011 Product_12 Furniture $ 376.03
P012 Product_13 Electronics $ 55.37
P013 Product_14 Books $ 116.55
P014 Product_15 Groceries $ 377.13
P015 Product_16 Electronics $ 368.53
P016 Product_17 Electronics $ 32.35
P017 Product_18 Clothing $ 112.49
P018 Product_19 Clothing $ 150.59
P019 Product_20 Electronics $ 341.86
P020 Product_21 Books $ 40.89
P021 Product_22 Electronics $ 282.27
P022 Product_23 Books $ 14.53
P023 Product_24 Electronics $ 418.19
P024 Product_25 Furniture $ 492.32
P025 Product_26 Furniture $ 354.71
P026 Product_27 Electronics $ 99.00
P027 Product_28 Clothing $ 261.07
P028 Product_29 Books $ 294.42
P029 Product_30 Furniture $ 395.90
P030 Product_31 Books $ 307.17
P031 Product_32 Groceries $ 117.02
P032 Product_33 Clothing $ 233.03
P033 Product_34 Clothing $ 440.65
P034 Product_35 Groceries $ 251.21
P035 Product_36 Clothing $ 360.62
P036 Product_37 Furniture $ 248.22
P037 Product_38 Groceries $ 357.19
P038 Product_39 Furniture $ 254.09
P039 Product_40 Furniture $ 423.83
P040 Product_41 Groceries $ 105.23
P041 Product_42 Books $ 388.93
P042 Product_43 Books $ 487.39
P043 Product_44 Clothing $ 432.53
P044 Product_45 Groceries $ 392.41
P045 Product_46 Furniture $ 492.67
P046 Product_47 Books $ 379.25
P047 Product_48 Books $ 11.98
P048 Product_49 Clothing $ 142.04
P049 Product_50 Clothing $ 211.14
P050 Product_51 Clothing $ 219.83
P051 Product_52 Clothing $ 155.94
P052 Product_53 Groceries $ 206.55
P053 Product_54 Electronics $ 69.12
P054 Product_55 Books $ 490.54
P055 Product_56 Clothing $ 209.00
P056 Product_57 Furniture $ 288.91
P057 Product_58 Books $ 178.37
P058 Product_59 Clothing $ 396.55
P059 Product_60 Clothing $ 211.57
P060 Product_61 Groceries $ 186.04
P061 Product_62 Electronics $ 205.75
P062 Product_63 Electronics $ 157.90
P063 Product_64 Groceries $ 389.86
P064 Product_65 Furniture $ 463.84
P065 Product_66 Electronics $ 169.40
P066 Product_67 Furniture $ 476.91
P067 Product_68 Books $ 16.83
P068 Product_69 Books $ 271.40
P069 Product_70 Electronics $ 159.25
P070 Product_71 Electronics $ 442.60
P071 Product_72 Books $ 132.81
P072 Product_73 Books $ 341.93
P073 Product_74 Electronics $ 407.11
P074 Product_75 Books $ 221.75
P075 Product_76 Electronics $ 378.55
P076 Product_77 Groceries $ 416.51
P077 Product_78 Clothing $ 195.73
P078 Product_79 Electronics $ 57.31
P079 Product_80 Furniture $ 135.51
P080 Product_81 Electronics $ 300.05
P081 Product_82 Books $ 243.47
P082 Product_83 Furniture $ 249.09
P083 Product_84 Furniture $ 234.67
P084 Product_85 Clothing $ 267.05
P085 Product_86 Electronics $ 226.59
P086 Product_87 Groceries $ 427.79
P087 Product_88 Furniture $ 222.39
P088 Product_89 Furniture $ 415.17
P089 Product_90 Groceries $ 259.58
P090 Product_91 Furniture $ 52.32
P091 Product_92 Books $ 333.42
P092 Product_93 Groceries $ 111.23
P093 Product_94 Books $ 425.16
P094 Product_95 Electronics $ 343.87
P095 Product_96 Electronics $ 97.40
P096 Product_97 Electronics $ 44.23
P097 Product_98 Books $ 14.75
P098 Product_99 Furniture $ 447.10
P099 Product_100 Furniture $ 75.40
P100 Product_101 Groceries $ 391.80
Product_ID Quantity_Sold product name price total
P002 12 Groceries $ 95.71 $ 1,148.52
P003 18 Books $ 355.19 $ 6,393.42
P004 8 Clothing $ 236.94 $ 1,895.52
P006 16 Groceries $ 110.38 $ 1,766.08
P009 15 Clothing $ 363.82 $ 5,457.30
P010 5 Electronics $ 24.92 $ 124.60
P013 6 Books $ 116.55 $ 699.30
P015 2 Electronics $ 368.53 $ 737.06
P017 6 Clothing $ 112.49 $ 674.94
P019 2 Electronics $ 341.86 $ 683.72
P020 4 Books $ 40.89 $ 163.56
P022 15 Books $ 14.53 $ 217.95
P024 4 Furniture $ 492.32 $ 1,969.28
P025 18 Furniture $ 354.71 $ 6,384.78
P026 17 Electronics $ 99.00 $ 1,683.00
P028 2 Books $ 294.42 $ 588.84
P029 15 Furniture $ 395.90 $ 5,938.50
P030 9 Books $ 307.17 $ 2,764.53
P032 5 Clothing $ 233.03 $ 1,165.15
P034 4 Groceries $ 251.21 $ 1,004.84
P035 11 Clothing $ 360.62 $ 3,966.82
P038 19 Furniture $ 254.09 $ 4,827.71
P040 11 Groceries $ 105.23 $ 1,157.53
P043 19 Clothing $ 432.53 $ 8,218.07
P044 18 Groceries $ 392.41 $ 7,063.38
P049 6 Clothing $ 211.14 $ 1,266.84
P050 7 Clothing $ 219.83 $ 1,538.81
P053 14 Electronics $ 69.12 $ 967.68
P055 15 Clothing $ 209.00 $ 3,135.00
P064 9 Furniture $ 463.84 $ 4,174.56
P065 13 Electronics $ 169.40 $ 2,202.20
P066 19 Furniture $ 476.91 $ 9,061.29
P068 14 Books $ 271.40 $ 3,799.60
P069 14 Electronics $ 159.25 $ 2,229.50
P070 5 Electronics $ 442.60 $ 2,213.00
P072 6 Books $ 341.93 $ 2,051.58
P073 6 Electronics $ 407.11 $ 2,442.66
P076 9 Groceries $ 416.51 $ 3,748.59
P077 18 Clothing $ 195.73 $ 3,523.14
P078 17 Electronics $ 57.31 $ 974.27
P080 6 Electronics $ 300.05 $ 1,800.30
P081 18 Books $ 243.47 $ 4,382.46
P083 15 Furniture $ 234.67 $ 3,520.05
P087 8 Furniture $ 222.39 $ 1,779.12
P089 11 Groceries $ 259.58 $ 2,855.38
P091 14 Books $ 333.42 $ 4,667.88
P092 6 Groceries $ 111.23 $ 667.38
P097 2 Books $ 14.75 $ 29.50
P098 4 Furniture $ 447.10 $ 1,788.40
P099 13 Furniture $ 75.40 $ 980.20

You might also like