Is there an easier solution to look up than control F lookup every solution?
Studying for an excel test and is there a vlookup function to find this than scrolling thru each number if they were, a few hundred numbers split away?
Best wishes,
Here's how I did it personally,
fie Home Ingen Page Layout Formulas Data Review View DERcper Help Macabacus Cuer Pivot " PMT SUMNJ3/812 C12 D G H Discounts 30 16110 TOIDT $ COE9 $ OOTT M N Units sold by Item 17045 17139 1/213 17245 Final Sales 1400 1700 1500 17001 -SUWU3121 1403 1800 1300 1900 1900 1100 1500 1900 1200 1800 1800 12001 1800 1400 1200 1000 Tatal Discunt -SUMJE*1312 CIZ) Calculate the total sales per peron using the Final Price from Question 1 SUN number in mer to the total discount given 7 Sale on Bob Amanda Robert Kylie ich Calculate the final price by applying the discount to all items over $50 All other items do not get a discount 1100 1900 1700 S 8 $ 0095 ST . . SO 01 SCOZE $$ $1 | $ Finland Replace X AW SI COME S 09 SCHE92 Find what 16910 Opcion * Item Price Final Price 2 16.200 S 20.00 S 20.10 31 $ 44.20 16902 $ 25.00 $ 18.20 5 16103 IS $ 30.005 21.00 6 16904 32.00 $ 22.40 7 16.05 S 7.00 $ 51.0 16906 $ 59.00 $ 41.20 16907 $ 80.00 10 160B $ 78.00 78.00 $ 54.60 11 16909 S 35.00 $ 25.20 12 16910 IS 9.00 27.30 13 16.119 20.00 TS 49.011 14 in 12 2.311 15 1913 S BOLU shoul 16 10914 S 37,00 25.90 17 16915 54.00 $ 37.80 1820910 45.00 $ 33.60 19 16917 $ 50.00 $ 35.00 20 20210 16913 IS 75.00 $ 52.50 21 16919 $ 65.00 46.20 22 16920 s 80.00 $ 56.00 23 16121 S 53.00 5 32.10 M.DOS 51.611 29 Th.03 2.211 . 21.110 S 49.711 27 30925 S 69.00 65.009 45.50 28 20926 IS $ 53.00 $ 37.10 29 16927 $ 74.00 $ $ 31.90 - 30 209235 49.00 30 28.00 31 16929 $ 53.09 37.20 32 16930 $ 56.00 $ 55.00 $ 39.20 33 1601 $69.00 S $ 48.30 34 dan 16:32 2.00 51.90 35 S 12.00 1h in S 73.110 37 31_W in 95 S 25.00 S 17.50 38 10935 S 27.03 S 19.90 16937 $28.00 $ 19.00 40 20938 S $ 64.00 $ 44.80 41 16939 $ 40.00 $ 28.00 42 16940 $ 79.00 $ 55.30 43 16941 65.00 $ 46.20 16542 $ 40.00 $ 28.00 45 123 S 26.00 S 18.20 1h Th.MS 36.116 SOS 2.611 Th15 25.1109 521 48 6945 S 25.00 S 32.50 4910947S00S 33.20 50 20945 $65.00 $ 46.20 51 16949 S 24.00 $ . $ $ 31.80 52 26950 $ 75.00 $ 32.30 53 G951 45.50 54 16952 $ 61.00 $ 42.70 55 1653 S $ 58,00 $ 40.60 56 1925 2.0 48.30 97 1A S 0.10 This 21.011 non 9.10 S 25.01. 99 10957 S 9.00 42.00 105 7ml 19 sn ins Pind Nest Cinse :. 1 SI NIVEL GE $$ $| $ $1 $ 00'59 116 fie Home Ingen Page Layout Formulas Data Review View DERcper Help Macabacus Cuer Pivot " PMT SUMNJ3/812 C12 D G H Discounts 30 16110 TOIDT $ COE9 $ OOTT M N Units sold by Item 17045 17139 1/213 17245 Final Sales 1400 1700 1500 17001 -SUWU3121 1403 1800 1300 1900 1900 1100 1500 1900 1200 1800 1800 12001 1800 1400 1200 1000 Tatal Discunt -SUMJE*1312 CIZ) Calculate the total sales per peron using the Final Price from Question 1 SUN number in mer to the total discount given 7 Sale on Bob Amanda Robert Kylie ich Calculate the final price by applying the discount to all items over $50 All other items do not get a discount 1100 1900 1700 S 8 $ 0095 ST . . SO 01 SCOZE $$ $1 | $ Finland Replace X AW SI COME S 09 SCHE92 Find what 16910 Opcion * Item Price Final Price 2 16.200 S 20.00 S 20.10 31 $ 44.20 16902 $ 25.00 $ 18.20 5 16103 IS $ 30.005 21.00 6 16904 32.00 $ 22.40 7 16.05 S 7.00 $ 51.0 16906 $ 59.00 $ 41.20 16907 $ 80.00 10 160B $ 78.00 78.00 $ 54.60 11 16909 S 35.00 $ 25.20 12 16910 IS 9.00 27.30 13 16.119 20.00 TS 49.011 14 in 12 2.311 15 1913 S BOLU shoul 16 10914 S 37,00 25.90 17 16915 54.00 $ 37.80 1820910 45.00 $ 33.60 19 16917 $ 50.00 $ 35.00 20 20210 16913 IS 75.00 $ 52.50 21 16919 $ 65.00 46.20 22 16920 s 80.00 $ 56.00 23 16121 S 53.00 5 32.10 M.DOS 51.611 29 Th.03 2.211 . 21.110 S 49.711 27 30925 S 69.00 65.009 45.50 28 20926 IS $ 53.00 $ 37.10 29 16927 $ 74.00 $ $ 31.90 - 30 209235 49.00 30 28.00 31 16929 $ 53.09 37.20 32 16930 $ 56.00 $ 55.00 $ 39.20 33 1601 $69.00 S $ 48.30 34 dan 16:32 2.00 51.90 35 S 12.00 1h in S 73.110 37 31_W in 95 S 25.00 S 17.50 38 10935 S 27.03 S 19.90 16937 $28.00 $ 19.00 40 20938 S $ 64.00 $ 44.80 41 16939 $ 40.00 $ 28.00 42 16940 $ 79.00 $ 55.30 43 16941 65.00 $ 46.20 16542 $ 40.00 $ 28.00 45 123 S 26.00 S 18.20 1h Th.MS 36.116 SOS 2.611 Th15 25.1109 521 48 6945 S 25.00 S 32.50 4910947S00S 33.20 50 20945 $65.00 $ 46.20 51 16949 S 24.00 $ . $ $ 31.80 52 26950 $ 75.00 $ 32.30 53 G951 45.50 54 16952 $ 61.00 $ 42.70 55 1653 S $ 58,00 $ 40.60 56 1925 2.0 48.30 97 1A S 0.10 This 21.011 non 9.10 S 25.01. 99 10957 S 9.00 42.00 105 7ml 19 sn ins Pind Nest Cinse :. 1 SI NIVEL GE $$ $| $ $1 $ 00'59 116
