Hi,
I am trying to use the value from a radio button, as an input (specifically the column variable) within the LookUp function (inside a label). Would anyone be able to provide any guidance?
Context: I am building a simple test app that shows price for a car. Enter the Brand, Model, and select between Base or Full Package and the label will display a price imported from a linked excel sheet. It works fine, except the label needs to consider either "Base" or "Full package" from the radio button. The code for the label is: LookUp(Table1,Model= Dropdown_Model.Selected.Model,'Full Package').
The issue is with the final variable 'Full Package', where I would prefer to keep something like: Text(Radio_Package.Selected.Value). But this just returns "Base" or "Full Package" as the final result in the label box.
