Match And Index Formula To Lookup Data From Table

[srizki]

Thank you very much.The formula is excellent, easy to understand and working great.
Can I also get the other formula Please, that would replace the first three digits as it described in my original question.
that if the first 3 digits match then replace as it is in short table.

Thanks again.