Can you use a dropdown list in a select formula

[Jpaulsen]

Hello, 

I am kinda lost here. Here is what I am trying to do. I want to use a select formula based on values entered in a form, then look for values that match it. I like to either use dropdown list or user input value. 

Here's my Example. 

Form

Type of Filter (Input value**) **Engine Oil Filter 

Part Number (Input Value**) **Part Number 

Formula I been trying to get to work is:

Select(ledcor[unit],

( [Part Number] = [type of Filter]), True) But it doesn't take the input value **Engine Oil Filter from Type of Filter. It looks for a column that is named Types of Filters. 

If I change [Type of Filter] to [Engine Oil Filter] it works. but I have more then one type of filters I want look for. In the main sheet it's broken down in to different types. Example "Engine oil Filter, Hydraulic Filter, Transmission Filter... etc. Now is excel I am able to do this but the formula does not transfer to AppSheet.