if-statement google-sheets match google-sheets-formula vlookup

Google Sheets Formula: Map String Value in Dropdown to Number for use in Formula?

Let's say I have a cell A1 with possible dropdown values {Apple,Banana,Cherry}. The chosen string determines which constant to use in the formula for B1. What is the best way to do this in Google Sheets?

Solution

if {Apple,Banana,Cherry} = {1,2,3} then try:

=MATCH(A1, {"Apple"; "Banana"; "Cherry"}, 0)

or:

=VLOOKUP(A1, {"Apple", 1; "Banana", 2; "Cherry", 3}, 2, 0)

How to swap the positions of Min and Max in an array?
Conversion operator and bool operator for if init expression
MATCH formula with multiple conditions returning true when false
Mysql How to only select from a column if the column exists
Unable to use IF statement in plpgsql
Trouble Excluding Named Worksheets from a Loop
Adding only some data labels and a total value at the top of my stacked bar chart
Good C-coding style for multiple lines if conditions
If statement to check if an array is not in another array
Determining if a string contains a word
How can I make a def function with my "if" statements?
How to assign a variable in an IF condition, and then return it?
Using or in if statement (Python)
C# Creating a Square
Return TRUE/FALSE column for checking if a set of columns contains a value/string
Does Go have "if x in" construct similar to Python?
Does if (myBool == true) differ computational wise to if(myBool)?
Write a Basic Car rental program on java / problems
Writing a "Chessboard" function in Python that prints out requested length of binary
Will my program execute "else" even if it executed my "if"?
Why Java does not see that Integers are equal?
How to have the Xcode 3.1 compiler warn of assignment operator in an if statement?
Nested if Statement good or bad?
How to write if statement in .tmux.conf to set different options for different tmux versions?
is not null Vs != null (Unity C#)
VBA "does not equal" code not stepping through IF statement as expected
Avoiding nested if else statement ladder in Python
I want to take output from a function to use in a IF statement in another function
What actually happens when we put conditions without [] (brackets) in if else block in a bash script?
C++ The if statement is still true even when only one condition is met