Forum Discussion
Excel IF Statement
I have a column of 200+ rows and each row has one of five different alpha codes (eg A, W, SE, etc.). The alpha codes correspond to five different six digit numerical codes (eg A=940007, etc.). Want t...
It's better to map alpha and numeric codes in helper range/table and LOOKUP(), VLOOKUP(), INDEX/MATCH or XLOOKUP (with what you are more familiar) one based on another.