sumifs-match/look up - maybe - Help

thefencegirl

New Member
Joined
Dec 3, 2014
Messages
18
:confused:Hello, I need some help please, I just can't get the right formula string to make this do what I need it to do. I need column D on the tracking page populated based off of several conditions. Since some items have to be sold together I created a Kit column, not sure if it would actually be required. Any help would be appreciated. Thank you! Sorry for the lay out I can't seem to locate how to post attachments



Data List Page:
Column A Column B Column C Column D
Kit Number Item Numbers Target Price Pay Out
(blank) 55555 $500.00 note: part of Kit 1
1 54123 $1,500.00 $100.00
(blank) 58769 $200.00 note: part of Kit 2
2 57546 $7,500.00 $300.00
3 55543 $40.00 $10.00
4 54752 $2,250.00 $450.00

Tracking Page:
Column A Column B Column C Column D
Kit Number Item Sold Number $Item Sold For Pay out amount note: D Needs to auto populate based off of being greater than target price from Data List Page.

1 54123 $1550.00 ?
0 55555 $ 500.00
0 58769 $ 200.00
2 57546 $7595.00
3 55543 $ 45.00
4 54752 $2225.00
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Hi, so the Column A might have blanks? Is this hard coded or the result of a pivot table?
 
Upvote 0
Hi, so the Column A might have blanks? Is this hard coded or the result of a pivot table?

Good morning Cyril, Column A may or may not be necessary it is add because I was not sure how to work around that some of the items had to be sold together to receive the pay out
 
Upvote 0
Good morning Cyril, Column A may or may not be necessary it is add because I was not sure how to work around that some of the items had to be sold together to receive the pay out

Ok, it is not clear how the data is setup, maybe a pivot table would suffice for you to get your summary? Have you tried? If yes what does work?
 
Upvote 0
Ok, it is not clear how the data is setup, maybe a pivot table would suffice for you to get your summary? Have you tried? If yes what does work?

Not sure a pivot table will work as well, I won't be working with this once it is set up and excel skills are very limited. Let's see if this will explain better.

Tracking Log Page


Excel 2007
ABCD
1Kit NumberItem Sold NumberItem Sold ForPay Out Amount
2154123$ 1,550.00Needs to Auto Populate based off of the Target Price
3055555$ 500.00
4058769$ 200.00
5257546$ 7,595.00
6355543$ 45.00
7454752$ 2,225.00
Tracking Log



Data List Page


Excel 2007
ABCD
1Kit NumberItem NumbersTarget PricePay Out
255555$ 500.00
3154123$ 1,500.00$ 100.00
458769$ 200.00
5257546$ 7,500.00$ 300.00
6355543$ 40.00$ 10.00
7454752$ 2,250.00$ 450.00
Data List
 
Upvote 0
Not sure a pivot table will work as well, I won't be working with this once it is set up and excel skills are very limited. Let's see if this will explain better.


Tracking Log Page


Excel 2007
ABCD
1Kit NumberItem Sold NumberItem Sold ForPay Out Amount
2154123$ 1,550.00Needs to Auto Populate based off of the Target Price
3055555$ 500.00
4058769$ 200.00
5257546$ 7,595.00
6355543$ 45.00
7454752$ 2,225.00
Tracking Log



Data List Page


Excel 2007
ABCD
1Kit NumberItem NumbersTarget PricePay Out *
255555$ 500.00
3154123$ 1,500.00$ 100.00
458769$ 200.00
5257546$ 7,500.00$ 300.00
6355543$ 40.00$ 10.00
7454752$ 2,250.00$ 450.00
Data List

Sorry, there has to be a >= in reference to the Target Price/Sold Price/ and payout
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,253
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top