Expression to get intersection value from a table

[Gopikrishnan_R]

Hi All,

Could someone pls help me to solve this? Appreciate quick response.

[dbaum]

LOOKUP

[Gopikrishnan_R]

No. It didn't solve the purpose. 

[Steve]

Then you used LOOKUP() wrong.

[Gopikrishnan_R]

I was expecting a reply with some sample expression. Anyway, Thanks for the comment on my comment. 

[Gopikrishnan_R · Accepted solution]

By the way I achieved it with Nested if along with Lookup by altering the table. I'm pretty sure there must a better way. 

[Steve]

Probably, but since you haven't shared any specifics, we can't offer specific recommendations.

[dbaum]

If you share the structure of your altered table and the expression you're using, likely experts here in the community can provide guidance.