INDEX/MATCH with Return Numbers Only

[Morey]

The following INDEX/MATCH formula works but, I would like the return to be just the numbers (no text). Help modifying formula would be appreciated.

 =IFERROR(INDEX('SDC TRIRIGA'!$C$1:$C$15000,MATCH(A2,'SDC TRIRIGA'!$A$1:$A$15000,0)),"")

Current Return:
[TABLE="width: 105"]
<tbody>[TR]
[TD="class: xl65, width: 105"]REQ-1187706[/TD]
[/TR]
</tbody>[/TABLE]
Would like this Return:
[TABLE="width: 105"]
<tbody>[TR]
[TD="class: xl65, width: 105"]1187706
[/TD]
[/TR]
</tbody>[/TABLE]
Regards,

Morey

 

[Fluff]

Will all the returns end in a 7 digit number?

 

[Morey]

Fluff,

That is an affirmative.

Morey

 

[Fluff]

In that case try
=IFERROR(RIGHT(INDEX('SDC TRIRIGA'!$C$1:$C$15000,MATCH(A2,'SDC TRIRIGA'!$A$1:$A$15000,0)),7)*1,"")
This will convert the text into a number. If you want to keep it as text, delete the part in red

 

[Morey]

In that case try
=IFERROR(RIGHT(INDEX('SDC TRIRIGA'!$C$1:$C$15000,MATCH(A2,'SDC TRIRIGA'!$A$1:$A$15000,0)),7)*1,"")
This will convert the text into a number. If you want to keep it as text, delete the part in red

Fluff,

That did it. Noticed, that the data has a space after the last digit (1187706 <----space found here). To account for this ",7)*1" was edited to ",8)*1". Any way to remove this excessive space after the last digit?

Thanks,

Morey

 

[Fluff]

The *1 should get rid of the space (assuming it's a normal space)

 

[Morey]

The *1 should get rid of the space (assuming it's a normal space)

Fluff,

After further investigation, you are correct the final return value is indeed space less. Thanks for all the help.



Regards,

Morey

 

[Fluff]

You're welcome & thanks for the feedback