Lookup formula for Dynamic label value from Cascading drop-down

[Greg_Holts]

I need to populate a calculated value with data associated with a value selected from a cascading drop-down

Basically, when I select Business Unit

and then select Task (The control for the Task dropdown is Task_dropdown)

I want  the associated value from the Why column to display in a Calculated Value box

I have tried to use this formula, but I can't get it to work

[kshubert]

I think the issue may be due to your lookup calculation, I believe the lookup should be
lookup("Playbook_task","Title",Task_dropdown,"Why"). To clarify there should not be quotations around the variable and there should be a comma between "Title" and the Variable.

[Greg_Holts]

Hi @kshubert 

Thank you very much for the reply

I used your formula and get the below:

I have tried swapping out ' for " and vice versa, but nothing seems to work

[Greg_Holts]

I got it working!

I swaped out 'Title for 'ID'

lookup("Playbook_task","ID",Task_dropdown,"Why")