Need help with Excel

New Contributor

I need a help! I have a scenario where if i type a number then it should give me a corresponding coded value based on alpabet on another column. see below screenshot. 

Numbers from 1 to 0 are coded using word BLACKWHITE

Where B=1, L=2 etc. 




3 Replies
best response confirmed by Hans Vogelaar (MVP)

@Lionel Charley Use below formula-


For dynamic array approach try- 




You are awesome. @Harun24HR. Perfect!. Thank you for the help.

Glad to know. If it helps then please tick mark the answer to treat the thread as solved.