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 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
=VLOOKUP(A3,$F$3:$G$7,2,FALSE)You can use VLOOKUP with a reference table. An alternative could be INDEX and MATCH.
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.
