Lookup another list to update items

[beatlefreak]

I have two SP lists: OrgChart & EventList.

OrgChart

users(person column)	Tier1	Tier2
A	Class1	Class1-a
B	Class1	Class1-b
C	Class2	Class2-a
D	Class3	Class3-a

EventList

EventName	Participants(multiple person column)	Created By	Tier1	Tier2
event1	A, B, C	A
event2	B	D
event3	C, D	B

So whenever someone creates item on EventList, I want to populate EventList Tier1 and Tier2 with information of both Participants and CreatedBy from OrgChart.

So for example for event1 on EventList, Tier 1 should be filled with "Class1, Class2" and Tier 2 should be filled with "Class1-a, Class1-b, Class2-a"....

Any help....? Thank you!

[v-liwei-msft · Accepted solution]

Hi @beatlefreak 

According to your needs, I made a test for your reference:

1.

2.

3.

4.

5.

Best Regards,

Levi

[beatlefreak]

thank you so much.....you are amazing!