Use Radio Button value as an input for the LookUp function

[Soham567]

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. 

[RandyHayes · Accepted solution]

@Soham567 

You would do this based on the radio selection in your formula:

With(LookUp(Table1,Model= Dropdown_Model.Selected.Model),
    Switch(Radio_Package.Selected.Value,
        "Full Package", 'Full Package',
        "Base", Base
    )
)

I hope this is helpful for you.

[Soham567]

It works, Thanks!