LookuoValue in Table

[pprakash]

Table-1Table-2Hi I have created a new column MBValue and lookup value accordingly. please see the formula. from table 2 I got id and event name and looking for this value in status column but data is not showing, please help.

FYI....Status is a calculated column.

[v-piga-msft]

Hi @pprakash,

Sorry for the delay.

Based on your images, I cannot see your formula clearly.

Please share some data sample which could reproduce your scenario and your desired output so that we could help further on it.

Best Regards,

Cherry