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