0
Follow
0
View

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

dengxiuhua546861350 注册会员
6 days ago

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)

About the Author

Question Info

Publish Time
6 days ago
Update Time
6 days ago