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

@BobWhiteJax 

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.

@BobWhiteJax 

=VLOOKUP(A3,$F$3:$G$7,2,FALSE)

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

vlookup.JPG