How do I create multiple if statments?

bucci35

Active Member
Joined
Jul 6, 2002
Messages
319
I have combo box that has 16 names to choose from and puts them in a1
I want to make a formula that says if a1=town, then 2, if a1=city then 2 and so forth..16 times. How can I do this?
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,839
Office Version
  1. 365
Platform
  1. Windows
It isn't quite clear if you want to create the formula on the Excel spreadsheet or in VBA.

If on the Excel sheet, create a lookup table for all of your values and use the VLOOKUP function (check out Excel's help on VLOOKUP for details and examples).

If in VBA, you can use a Select Case statement, for example
Code:
Select Case Range("A1")
   Case "town"
      Range("B1")=1
   Case "city"
      Range("B1")=2
...
   Case Else
      Range("B1")=99
End Select
 

Watch MrExcel Video

Forum statistics

Threads
1,113,811
Messages
5,544,448
Members
410,611
Latest member
JB_101920
Top