VC grab difference column value base on enumlist reference values

[ckng6218]

I create an appsheet with 2 table view base on 2 difference sheet(Sheet1 & Sheet2) show as below,

 Sheet1

Sheet2

I create an Enumlist Ref for [Installed PC] with below formula and it working fine,

SELECT(
Sheet1[Staff PC],
IN(
[Staff PC],[_THISROW].[Installed PC]
)
)

My question is i want to create a VC(Staff Name) at sheet2 table beside [Installed PC], and i want that VC grab the Staff Name value base on [Installed PC] references, the VC coloumn output for soft1 row should be Ace,Bravo

So far i dont have any idea how to start the VC formula.

[TeeSee1 · Accepted solution]

How about

SELECT(
 Sheet1[Staff Name],
 IN(
  [Staff PC], [_THISROW].[Installed PC]
 )
)

[ckng6218]

GREAT!!! You save my day 😁