combine formula into one formula

[jmkerzic]

Not sure how to combine this into one formula.

=IF(ISNUMBER(SEARCH("m",Invoices!C2)),"DC","DS")
=IF(ISNUMBER(SEARCH("c",Invoices!C2)),"DC","DS")

Thanks,

Matt

 

[Eric W]

Try:

=IF(OR(ISNUMBER(SEARCH({"m","c"},Invoices!C2))),"DC","DS")

 

[jmkerzic]

Thanks.

I need a formula for the following please:

I have a column that has the following in it, and I want it to search and return the value.

any number = 5210
m = 5215-25
c = 5240-45
b = 5240-40

So if there is a number return,5210, M return 5215-25, a C return 5240-45, and b return 5240-40.

Matt

 

[Eric W]

Is this what you need?

Book1
	A	B
1	Start	Value
2	1	5210
3	m	5215-25
4	c	5240-45
5	b	5240-40
6	23	5210
7	c	5240-45
Invoices

Cell Formulas
Range	Formula
B2	=IFERROR(VLOOKUP(A2,{"m","5215-25";"c","5240-45";"b","5240-40"},2,0),5210)

Note that this only works if you have the actual value "m" (or "M"). If the m is part of a larger string like "123m" then I'll need to revise this.

 

[jmkerzic]

Thanks Eric. It should work. I onle have one character in the column where the formula is referencing.