Use of LOOKUPVALUE

[Syndicate_Admin]

Good morning guys, I would like your support on this topic:

What I would like is to be able to take the Advance of this table1

Article	WEEK	Advance	Concatenated
BASIC	0	0%	0BASIC
BASIC	1	3%	1BASIC
BASIC	2	6%	2BASIC
SEMI FASHION	0	0%	0SEMI FASHION
SEMI FASHION	1	4%	1SEMI FASHION
SEMI FASHION	2	8%	2SEMI FASHION
SEMI FASHION	3	13%	3SEMI FASHION
SEMI FASHION	4	18%	4SEMI FASHION
SEMI FASHION	5	23%	5SEMI FASHION
SEMI FASHION	6	28%	6SEMI FASHION
SEMI FASHION	7	34%	7SEMI FASHION
SEMI FASHION	8	40%	8SEMI FASHION

to this table2, respecting the weeks since as you can see the progress is increasing according to item

Article	WEEK	Advance	Concatenated
BASIC	0		0BASIC
BASIC	1		1BASIC
BASIC	2		2BASIC
SEMI FASHION	0		0SEMI FASHION
SEMI FASHION	1		1SEMI FASHION
SEMI FASHION	2		2SEMI FASHION
SEMI FASHION	3		3SEMI FASHION
SEMI FASHION	4		4SEMI FASHION
SEMI FASHION	5		5SEMI FASHION
SEMI FASHION	6		6SEMI FASHION
SEMI FASHION	7		7SEMI FASHION
SEMI FASHION	8		8SEMI FASHION

Thanks for the reply:

[amitchandak]

@Syndicate_Admin , refer if these options can help

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.