Assigning one value to multiple unique IDs?
I recently inherited a monster of a spreadsheet and I'm working on a project where I need to calculate billbacks down to the item level but at the moment they are calculating at the Table level.
Each table can have multiple price points and billback amounts.
Ex) Row 1 - Table AL3 is being sold at $35 and the charge back amount is $5
Row 2 - AL3 is being sold at $35.50 and the charge back amount is $2.50
Table AL3 contains 40 unique values that I need to match with each of the 3 unique IDs above, returning 120 unique rows. Hopefully that makes sense..
I'm currently at a loss regarding how to go about this. I read that using a lookup, index and Match functions might work but I was not able to work out exactly how.
Any help at all would be greatly appreciated!
[link] [comments]
Want to read more?
Check out the full article on the original site