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.
Current Return:
<tbody>
</tbody>Would like this Return:
<tbody>
</tbody>Regards,
Morey
Code:
=IFERROR(INDEX('SDC TRIRIGA'!$C$1:$C$15000,MATCH(A2,'SDC TRIRIGA'!$A$1:$A$15000,0)),"")
Current Return:
REQ-1187706 |
<tbody>
</tbody>
1187706 |
<tbody>
</tbody>
Morey