I need a formula for H34, over there from the A33:C68 is the array, and I'm required to have a VLOOKUP formula that can be combined with any other formula to calculate the total spend at Walmart. As shown on the bottom, the SUM total of Walmart is $185.68, but I need a formula that includes the VLOOKUP. Again I need a formula that contains VLOOKUP that can be combined with any other formula, but I need the result to come out as $185.68. Thank you

Final Project 3110 View Share Comments Insert v ab Wrap Text Accounting Do 49- o DX Delete WEX $ %) Merge & Center .00 00 0 Ideas Conditional Format Cell Formatting as Table Styles Sort & Filter Format Find & Select Sensitivity F G H 1 J K L M N 0 P Q R Miscellaneous Card Expense 4/5-5/2 Spend Walmart Gas Starbucks koji Mcdonalds Bar Other Walmart $ 185.68 42 Starbucks AutoSave Home Insert Draw Page Layout Formulas Data Review X Calibri (Body) 12 ~ AF = = LO Paste B I U a. A v H44 x fx =SUM(C34,039,045,C50,C53,C61) B D E 31 32 33 Store Date Reason 34 Walmart 4/5/20 $ 28.54 Grocery 35 Gas Das 4/5/20 $ 17.50 Gas for the week 36 Starbucks 30 Starbu 4/6/20 $ 10.60 Girlfriend/Me 37 Koji 17720 4/6/20 $ 13.60 Night shift Dinner 38 Starbucks 4/7/20 $ so staro 4711 5.41 Me Caramel Frap 39 Walmart 4/7/20 $ " 4.96 Battery for controller 40 Mcdonalds 4/7/20 s 7.98 Breakfast girlfriend Mida " 41 Mcdonalds 4/8/20 $ 9.48 Breakfast Coffee * Moon 100 4/10/20 $ 10.60 Girlfriend/ Me 43 Other 4/10/20 $ other 64.76 Movies with girfriend 44 Koji 4/11/20 $ 9.83 Night Shift dinner 45 Walmart 4/12/20 $ 45.55 Grocery *3 Wam 46 Gas 4/12/20 $ 10.00 Gas Tor 18.60 Gas for the week 47 Other 4/14/20 $ 21.40 Lunch break 2008 48 Bar 4/14/20 $ 29.80 Tuesday night NBA mo Me 49 Starbucks 4/15/20 $ 5.41 Me Caramel Frap Marx ... 50 Walmart 4/15/20 $ 13.46 Snacks cool iteam Made 51 Mcdonalds 4/16/20 $ 7.98 Breakfast girlfriend ma 52 Mcdonalds 4/18/20 $ 7.98 Breakfast girlfriend cana 53 Walmart 4/19/20 $ 45.28 Grocery Max 54 Gas 4/19/20 $ 20.65 Gas for the week 55 Bar 4/21/20 $ 68.69 Tuesday night NBA 56 koji 4/22/20 $ 21.22 Girlfriend/Me Max 57 Mcdonalds 4/23/20 $ 7.98 Breakfast girlfriend co. WW 58 Other 4/24/20 $ 25.88 Lunch break We 59 Other 4/25/20 $ 36.78 Breakfast girlfriend 22 10 60 Starbucks 4/25/20 $ 10.60 Girlfriend/Me 61 Walmart 4/26/20 $ 47.89 Grocery Woci 62 Gas 4/26/20 $ 19.47 Gas for the week W 200 Wat 63 Mcdonalds 4/29/20 $ 7.98 Breakfast girlfriend 64 Other 4/30/20 $ 15.76 Campus food ce 65 Starbucks 5/1/20 $ 5.41 Me Caramel Frap ce 66 Other 5/1/20 $ 20.66 Lunch break 67 Other 5/2/20 $ 32.54 Breakfast girlfriend 68 Other 5/2/20 $ 78.32 Escape room 69 Total miscellaneous expense $ 798.55 70 71 Sheet1 + Ready A O - + 100%