Hello,
Please could you kindly assist,
I have an excel summary doc, which i am trying to prepare.
The requirements are for me to provide a summary page of Raw data in a vertical way as appose to current data that is horizontally...
I am trying my level best to take two variables "Store ID" which is a consistent cell vertically (Rows) and link it too a Cell Title (Column) which is horizontally to give me a specific output in the same row as the store ID...eg IF Store ID (X) has a returning value for Z whilst linking up to value in (Y - this being the product name)...
Basically Store ID in conjunction with Product name will give me a product price in a vertical manner, this is required for multiple store's and values may vary dependent if store has price for that unit, so i cant work on a set standard of rows vertically on summary page for one store ID, as they change week by week
I dont know if anyone understands what i need to do, but i have been looking at linking Store ID and Product name in a Vlookup but the only issue i have is the column index varies for each product with the same store ID. (There could be multiple products for one store and 3 in another store)
If anyone is by the means to assist me, please help.
Thank YOU!!!!!
Please could you kindly assist,
I have an excel summary doc, which i am trying to prepare.
The requirements are for me to provide a summary page of Raw data in a vertical way as appose to current data that is horizontally...
I am trying my level best to take two variables "Store ID" which is a consistent cell vertically (Rows) and link it too a Cell Title (Column) which is horizontally to give me a specific output in the same row as the store ID...eg IF Store ID (X) has a returning value for Z whilst linking up to value in (Y - this being the product name)...
Basically Store ID in conjunction with Product name will give me a product price in a vertical manner, this is required for multiple store's and values may vary dependent if store has price for that unit, so i cant work on a set standard of rows vertically on summary page for one store ID, as they change week by week
I dont know if anyone understands what i need to do, but i have been looking at linking Store ID and Product name in a Vlookup but the only issue i have is the column index varies for each product with the same store ID. (There could be multiple products for one store and 3 in another store)
If anyone is by the means to assist me, please help.
Thank YOU!!!!!
