excel formula

Copper Contributor

Can anyone help me, whats the formula i need to use base on the attach file. when i need to key in the number at "number" column, the result column will automatically generate based on table 1 and sorting.

 

 

2 Replies

@antan78 

Why would 7659 convert to efkn and not to edgn or elcn?

 

hi, ya, it follow the number next to each other only