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: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Chemistry
1.2K views

1. (3) Acetone is a more polar solvent than diethyl ether. With reference to the structures...

Biology
1.2K views

Who may introduce a bill in the state legislature O Citizens Member of the legislature...

Basic Math
1.2K views

A guy wire runs from the top of a cell tower to ametal stake in...

Basic Math
1.2K views

A chemistry lab requires students to identify chemical compounds by using various tests. Each student...

Statistics
1.2K views

Consider the density curve plotted below PDF X 0 11 0 1 0 09 0...

Statistics
1.2K views

The dataset below represents a sample of text messages sent during math class in a...

Calculus
1.2K views

Listen Use differentials and the volume of a sphere to estimate the amount of paint...

Calculus
1.2K views

t up a definite integral for the volume of the solid generated by revolving the...

Calculus
1.2K views

Find the area of the following region expressing your result in terms of the positive...

Algebra
1.2K views

Find the domain of the following function Do not use a graphing calculator 1 2...

Accounting
1.2K views

Sean is 49...

Finance
1.2K views

Suppose there are perfect capital markets with taxes. Investors expect a company to have $120...