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.

[Admin]

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.

See my second formula.

[srizki]

Okay, Thanks

But how would your second formula know that what should replace, it needs to match before, right?
% to be allocated to Operating exp % to be allocated to Maintenance exp Maintenance account
8560001 13% 27% 863
8530000 18% 32% 864
8570000 70% 30% 865
8500001 10% 20% 861
8590000 10% 20% 867

so, the formula should find for example 856 and then replace first three to 863.