I have an IF statement formula already and I wanted to know if I could insert
another one, inserting certain numbers.

Example:
1101(data coming in) and I want to insert 310(for every one) in
front while picking up the first four digits. The problem is that the data
coming in is not always consistent.

Below is my IF Statement:

=IF(ISERR(VALUE(LEFT(A2752,1))2),H2751,IF(VALUE(L EFT(A2752,1))2,VALUE(LEFT(A2752,4)),VALUE(LEFT(A2 752,2))))

Thanks in advance.

Hi,

I don't understand this.
What value do you have in A2752? Give examples of other values.
What value do you expect the formula to output?

Mike

"mcp201" wrote:

I have an IF statement formula already and I wanted to know if I could insert
another one, inserting certain numbers.

Example:
1101(data coming in) and I want to insert 310(for every one) in
front while picking up the first four digits. The problem is that the data
coming in is not always consistent.

Below is my IF Statement:

=IF(ISERR(VALUE(LEFT(A2752,1))2),H2751,IF(VALUE(L EFT(A2752,1))2,VALUE(LEFT(A2752,4)),VALUE(LEFT(A2 752,2))))

Thanks in advance.

I actually get values from two different places. One value coming in for
example is 31011101(A2752) and another is 1101. I want the VLOOKUP to insert
the 310 in front of the data from the second source. I expect to get the 3101
number for both sources. I understand how it is done for the first source,
but not the second. I am currently manually inputting the 310 in front of the
second source.



"Mike H" wrote:

Hi,

I don't understand this.
What value do you have in A2752? Give examples of other values.
What value do you expect the formula to output?

Mike

"mcp201" wrote:

I have an IF statement formula already and I wanted to know if I could insert
another one, inserting certain numbers.

Example:
1101(data coming in) and I want to insert 310(for every one) in
front while picking up the first four digits. The problem is that the data
coming in is not always consistent.

Below is my IF Statement:

=IF(ISERR(VALUE(LEFT(A2752,1))2),H2751,IF(VALUE(L EFT(A2752,1))2,VALUE(LEFT(A2752,4)),VALUE(LEFT(A2 752,2))))

Thanks in advance.