Good evening,
I hope you are in good health.
My name is David and I use this forum because I am unable to find a solution to my problem.
I have two Excel files.
One in which I have the database of product references by date and by manufacturer (TodasPropostasPortugal), separated by TAB's for easy change when there are new price lists.
In that same file, it is divided by columns of:
****A | B | C | D | E | G | H
Brand | Reference | Description | Price | Price Group | Discount Group | Discount
Another file where I have is "FolhaPropostas_TIPO_23_03_2020” that will read information in the "TodasPropostasPortugal".
I've already managed to do some of the things I wanted to do, but right now I can't move forward
What is intended I will try to exemplify here.
In column C of the file “FolhaPropostas_TIPO_23_03_2020” references are placed:
For example references (I put already the 3 references):
MTN649212
52900
TXA624C
What will happen (it is already done) is that the formula will automatically search and put the description, brand, list price and Price Group, example:
Refª || DESCRIPTION || BRAND || TABLE PRICE || PRICE GROUP
MTN649212 || ACT.BIN.REG-K-12x230-10 C-OP.MANUAL || SCHNEIDER || 596.72€ || GP4
052900 || Gira HomeServer 4 Gira Server || GIRA || 2128,65€ || 5
TXA624C || Actuator blinds / pers. 4 channels 230V KNX || HAGER || 238.56€ || 42
What I want and do, and don't know how to do it, is that when I type a reference, make me an allocation of the corresponding discount for each product listing.
For example, in the Excel "TodasPropostasPortugal" file under the "SCHNEIDER" tab, there is a table of price groups (columns H and I) where it shows for example:
GROUP || Discount
GP1 || 52.00%
etc
For the GIRA brand, the price group is different:
GROUP || DISCOUNT
1 || 45%
2 || 35%
etc
For the HAGER brand, the price group is different:
GROUP || DISCOUNT
22 || 45%
23 || 40%
etc
And each manufacturer has its own discount groups.
What was intended is that on the "Excel "FolhaPropostasTIPO_23_03_2020" column J and Q should be filled with the discount according to each price group of each manufacturer.
Example I gave at SCHNEIDER would appear in the discount >> 45% (corresponding to the GP4 group)
In GIRA, the discount would appear >> 20% (corresponding to group 5)
At HAGER, the discount would appear >> 50% (corresponding to group 42)
The problem is that each manufacturer has its price groups and I am not able to make each discount appear and associate it with the correct discount group.
I humbly ask if anyone around here can help
Thanking you in advance for any help you can give me.
I leave the two files attached.
David
Bookmarks