Index

[Stclements1]

I have various suppliers providing multiple products.
What I want to do is have a list of all meat suppliers, fruit suppliers, confectionary suppliers etc etc
So each time a product is purchased the value of that purchase goes into column D, then the index looks up what that particular supplier supplies and place the value in the relevant column. Meat supplies in column F, Sweet suppliers in column G and so on. Because there are multiple suppliers providing the same headline product such as meat, pastries sweets, I want to create either a lookup or index that will determine what the supplier supplies and put the value of that purchase in a pre-determined column such as meat, sweets, etc so at the end of each month I can see my gross spend on each provision rather than just the individual suppliers cost.

Column A
suppliers name

Column D gross cost

Column F Meat
Column G Sweets
Column H Pastries

if the supplier is Fred's meats it puts the value in the corresponding cell in column D into column F
if the supplier is Karen's sweets it puts the value in the corresponding cell in column D into column G
etc etc

 

[HighAndWilder]

I have various suppliers providing multiple products.
What I want to do is have a list of all meat suppliers, fruit suppliers, confectionary suppliers etc etc
So each time a product is purchased the value of that purchase goes into column D, then the index looks up what that particular supplier supplies and place the value in the relevant column. Meat supplies in column F, Sweet suppliers in column G and so on. Because there are multiple suppliers providing the same headline product such as meat, pastries sweets, I want to create either a lookup or index that will determine what the supplier supplies and put the value of that purchase in a pre-determined column such as meat, sweets, etc so at the end of each month I can see my gross spend on each provision rather than just the individual suppliers cost.

Column A
suppliers name

Column D gross cost

Column F Meat
Column G Sweets
Column H Pastries

if the supplier is Fred's meats it puts the value in the corresponding cell in column D into column F
if the supplier is Karen's sweets it puts the value in the corresponding cell in column D into column G
etc etc

If you only want the gross spend on each provision at the end of each month then it is best to just calculate it then from the data that you have collected during the month.

Are you able to use XL2BB to post a copy of your sales data that gets collected as sales are made.

Also a copy of the data that you want to lookup into to ascertain what that particular supplier supplies.