Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. i need help with the formula in cell g3, i have tw

I need help with the formula in cell G3, I have two different workbooks and...

80.2K

Verified Solution

Question

Accounting

I need help with the formula in cell G3, I have two different workbooks and I am trying to add a formula that adds the units that are being delivered next to the units that are in the store by label, size and color.

I did a concatenate formula on column A that combines label, size and color and use this as my lookup value on both reports. There are two delivery dates. I used a formula that looks up the value and returns the units that are coming in the future for both delivery dates next to what is in store.

My problem is that there are multiple order #s for the same style, color size. For example the lookup highlighted in yellow that is in store 45356sred is on report #2 and is under two different orders, when I use the current formula the vlook up only returns the first match it finds which is delivery 7/10 ( 78 units) and 8/10 (56 units) for a total of 134 units. However I need formula thay also includes the units in row 34. The total units should be 286 units.

What formula can I use for this problem? Is theres a formula that can look up the value and if it comes up multiple times, it adds the results? image

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

A freshwater biome is defined by the lack of A dissolved oxygen C biodiversity B...

Biology
Q

Maximum acceleration of the train at which a box lying on its floor will remai...

Physics
Q

n y 2sin x 5x Step 2 of 2 Determine how the general shape of...

Geometry
Q

ne information provided 1 Parallel Line Construction For this part of the assignment you will...

Geometry
Q

What is the area of triangle ABC given m

Basic Math
Q

B2 Take S to be the set that is given by S x y x...

Calculus
Q

A 2 Find the determinant of given matrix using cofactor expansion 1 0 1 0...

Algebra
Q

Christine purchased a franchise agreement to distribute electronic gadgets for 10 years. The agreement cost...

Accounting
Q

Neslund Ornamentals offered a 2% trade discount to Parsons Retail Outlet for all purchases over...

Accounting
Q

22- Information that is gathered by management only if the benefits derived from the information...

Accounting
Q

Part 1-10 help on ...

Accounting
Q

Twice a year, Rowdy (40% shareholder) and Q (40% shareholder) travel to various locations across...

Finance