Cliffork
New Member
- Joined
- Feb 12, 2020
- Messages
- 21
- Office Version
- 365
Hi guys,
I have a set of cells that I've shown above for reference. The first lists what customer's equipment I am currently working on. The second is on a later sheet, and if it is "Customer 1" in my customer cell, it placed a note to remind me they have specific shipping instructions.
I now have a second customer that is requesting something specific, and I would like to change this into something like an OR function, that says "if Customer 1, note 1. if Customer 2, note 2." But I cannot seem to get an OR function to work this way, I keep getting errors. Either I'm misunderstanding how OR functions should be written, or their purpose in general. Help?
| Meter Repair Compilation File -Template.xlsm | |||
|---|---|---|---|
| B | |||
| 3 | Customer 1 | ||
| 4 | REMINDER: Ship on our account with 2-day shipping | ||
Customer Info | |||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| B4 | B4 | =IF(ISNUMBER(SEARCH("Customer 1",B3)),"REMINDER: Ship on our account with 2-day shipping","") |
I have a set of cells that I've shown above for reference. The first lists what customer's equipment I am currently working on. The second is on a later sheet, and if it is "Customer 1" in my customer cell, it placed a note to remind me they have specific shipping instructions.
I now have a second customer that is requesting something specific, and I would like to change this into something like an OR function, that says "if Customer 1, note 1. if Customer 2, note 2." But I cannot seem to get an OR function to work this way, I keep getting errors. Either I'm misunderstanding how OR functions should be written, or their purpose in general. Help?
