» Encoding a Sequence of Letters
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Column A contains a series of letters, column B contains matching codes for each letter.
We want to create new strings composed of the codes matching each of the letter strings shown in column D.
Solution:
Use the VLOOKUP and MID functions as shown in the following formula:
=VLOOKUP(MID(D2,1,1),$A$2:$B$7,2,FALSE)&" "&VLOOKUP(MID(D2,2,1),$A$2:$B$7,2,FALSE)&" "&VLOOKUP(MID(D2,3,1),$A$2:$B$7,2,FALSE)
Book Store:
Recommended Books:
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Microsoft Excel VBA Programming for the Absolute Beginner
- How to Read A Financial Report
- Analyzing Markets, Products, and Marketing Plans
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
vlookup
ghulam raza
u can do this command by using lookup wizard in the tools menu, if ur look up wizard is not installed go to the add-ins and then u can install it.
=VLOOKUP(MID(D2,1,1),$A$2:$B$7,2,FALSE)&" "&VLOOKUP(MID(D2,2,1),$A$2:$B$7,2,FALSE)&" "&VLOOKUP(MID(D2,3,1),$A$2:$B$7,2,FALSE)". WOULD U HELP ME PLZ.