thefencegirl
New Member
- Joined
- Dec 3, 2014
- Messages
- 18
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
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