How to look up first instance of a numbered list

JZCG

I have a module (Module A) that applies to a list.

	Job Title	Salary
Bob
John
Katie

I have a different module (Module B) that uses a numbered list. The display names of the numbered list matches the names in the regular list.

How do I look up the first instance of the "Job Title" in Module B so Module A shows Bob's Job Title is A?

	Job Title	Salary
Bob (#1)	A
John (#2)	B
Katie (#3)	C

rob_marshall

@JZCG

In your numbered list, what format is the Display Name property? If it is TEXT, change it to List formatted to be the Employee Flat list (what the first module is dimensionalized by). Then, in Module A, your formula would be ModuleB.Job Title[FirstNonBlank:Numbered List.Display Name].

Rob