aka_krakur
Active Member
- Joined
- Jan 31, 2006
- Messages
- 438
I have a column of data that looks like this:
In column B I need a formula, with an end result that tells me whether A is a 80cm or a 135cm, Unknown, or "Other"
Is there a formula like =isnumber(search)...that could do this?
Book2 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | PART_NAME | |||||
2 | FDAABSOL.0358.0MMX20MMX135CM | |||||
3 | UNKABSOLUTE | |||||
4 | FDAABSOL.0356.0MMX100MMX135CM | |||||
5 | FDAABSOL.0356.0MMX60MMX135CM | |||||
6 | CEABSOL.0358.0MMX80MMX80CM | |||||
7 | FDAABSOL.03510.0MMX40MMX80CM | |||||
8 | FDAABSOL.0357.0MMX100MMX135CM | |||||
9 | CEABSOL.0358.0MMX30MMX135CM | |||||
10 | CEABSOL.03510.0MMX60MMX80CM | |||||
11 | UNKABSOLUTE | |||||
12 | FDAABSOL.0356.0MMX60MMX135CM | |||||
13 | FDAABSOL.0357.0MMX100MMX135CM | |||||
14 | FDAABSOL.0358.0MMX60MMX135CM | |||||
15 | FDAABSOL.0357.0MMX30MMX80CM | |||||
16 | FDAABSOL.0356.0MMX100MMX135CM | |||||
17 | FDAABSOL.0357.0MMX100MMX135CM | |||||
18 | FDAABSOL.0358.0MMX60MMX80CM | |||||
19 | FDAABSOL.0356.0MMX30MMX135CM | |||||
20 | FDAABSOL.0358.0MMX100MMX80CM | |||||
21 | CEABSOL.0357.0MMX60MMX80CM | |||||
22 | RXACCUNET,5.5,190FDA | |||||
23 | RXACCUNET,7.5,190FDA | |||||
24 | RXACCUNET,6.5,190FDA | |||||
25 | RX.014ACCULINKII6-8/30CE | |||||
26 | UNKNOWNRXACCUNET | |||||
27 | 5.5RXACCUNET,190CE | |||||
Sheet1 |
In column B I need a formula, with an end result that tells me whether A is a 80cm or a 135cm, Unknown, or "Other"
Is there a formula like =isnumber(search)...that could do this?