[Table]Food Choice Table
I want to take the values from the column and insert on the choice. Can anyone suggest how can this be done in excel and power BI.
E.G this is how this should look like.
CodePudding user response：
In Excel, a "nested if" isn't elegant but it will work for your case. Assuming Menu is in the B column, Toffee is in the D column, Coffee is in the E column, and Chinese is in the F column here is the formula for your Choice column starting on row 2.
=IF(B2="Toffee",D2,IF(B2="Coffee",E2,IF(B2="Chinese",F2,"Not Found")))
If this solves your problem please accepts this as the solution using the check mark to the left.