vlookup error

[cyee]

Dear Guru,

I'm using

Please Login or Register  to view this content.

to get my no from a statement.
However, because the result contain of spacing. Hence i was unable to vlookup the data i wanted.

Appreciate if you could help to trim away the spacing in column M on the attached sample.

TIA!!!

[bebo021999]

M5:
MM1234567S
lookup value:
MM12345672

That is why vlookup did not work.

[bebo021999]

OK, try again

In M5:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[cyee]

It's only work when it is only number. It will not work if it contain alphabet example I123456S.


I reattached the new sample here with more scenario.

Appreciate you could help again.

[Bo_Ry]

Please try

Please Login or Register  to view this content.

M5
=IFERROR(--GetDraftNo(L5),GetDraftNo(L5))

[cyee]

Thank you very very much Bo_Ry!!!
Perfectly done!!!!!