# If col 1 = a, b or c make col 2 = x

#### zone out

##### New Member
Greetings excel friends,

If col 1 = a, b or c make col 2 = x
but with mutiple occurances.
also if Col 1 = d, e or f make col 2 = y
if col 1 = g, h or j make col 2 = z etc.

Richard

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
Greetings excel friends,

If col 1 = a, b or c make col 2 = x
but with mutiple occurances.
also if Col 1 = d, e or f make col 2 = y
if col 1 = g, h or j make col 2 = z etc.

1. Explain what you mean by "with multiple occurences".

2. You said you want 'y' if Column 1 equals g, h or j... did you mean to deliberately skip the letter 'i'?

3. What comes after "z"; that is, what do you want if Column 1 equals g, h or j (or i depending on how you answer #2)?

Rick,
Thanks for your reply. Thought letters and number would be easier - sorry for confusion.

Spreadsheet has data for wagon maintenance.
Col B
- Inspect wheels
- Repairs
- Shunting
- Lifting
- Lifting Wagons

So I want these items (events) to equal a number in Col H.
- Inspect wheels = 10
- Repairs = 20
- Shunting = 30
- Lifting = 40
- Lifting Wagons = 40

Sometimes multiply events = the same number.

Hope this makes sense?

Richard

Last edited:

Replies
5
Views
284
Replies
4
Views
139
Replies
4
Views
133
Replies
5
Views
271
Replies
3
Views
235

1,203,051
Messages
6,053,221
Members
444,648
Latest member
sinkuan85

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back