Excel IF Statement

Occasional Contributor

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 to do an IF statement to get the right numeric code in each of the 200+ rows.  Thought I knew how to do it, but not working.  Thank you.

2 Replies


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.



You can use VLOOKUP with a reference table. An alternative could be INDEX and MATCH.