This2willpass
New Member
- Joined
- Aug 27, 2015
- Messages
- 3
Hello All,
I have a store list with prices and I am hoping to find a formula to help.
In the attached file there are 4 sample columns. Flavor, Item #, Store, Price.
The issue I have is when adding a new flavor it does not contain a price. I would like it to be able to copy the price from the original flavors to the corresponding sizes of the new flavors(Original Small = Green Small). However given that each store has a different price it would need to be contingent to a matching store number. I don't know if item number helps in this at all.
I understand that I can simply go in and copy and paste however My sheet has 250k+ rows from 100 different stores so i made the excel sample as simple as I could.
Any and all insight is greatly appreciated. Thank you in advance.
<tbody>
</tbody>
I have a store list with prices and I am hoping to find a formula to help.
In the attached file there are 4 sample columns. Flavor, Item #, Store, Price.
The issue I have is when adding a new flavor it does not contain a price. I would like it to be able to copy the price from the original flavors to the corresponding sizes of the new flavors(Original Small = Green Small). However given that each store has a different price it would need to be contingent to a matching store number. I don't know if item number helps in this at all.
I understand that I can simply go in and copy and paste however My sheet has 250k+ rows from 100 different stores so i made the excel sample as simple as I could.
Any and all insight is greatly appreciated. Thank you in advance.
Flavor | Item# | Store | Price |
Original | | NY | |
Small | 101 | NY | 2.00 |
Medium | 102 | NY | 3.00 |
Large | 103 | NY | 4.00 |
*********** | | NY | |
Green | | NY | |
Green Small | 111 | NY | |
Green Medium | 112 | NY | |
Green Large | 113 | NY | |
*********** | | NY | |
Blue | | NY | |
Blue Small | 121 | NY | |
Blue Medium | 122 | NY | |
Blue Large | 123 | NY | |
| | | |
| | | |
Original | | CA | |
Small | 101 | CA | 2.15 |
Medium | 102 | CA | 3.15 |
Large | 103 | CA | 4.15 |
*********** | | CA | |
Green | | CA | |
Green Small | 111 | CA | |
Green Medium | 112 | CA | |
Green Large | 113 | CA | |
*********** | | CA | |
Blue | | CA | |
Blue Small | 121 | CA | |
Blue Medium | 122 | CA | |
Blue Large | 123 | CA | |
<tbody>
</tbody>
Last edited: