CATEGORY: Excel Text Formulas VERSIONS: All Microsoft Excel Versions

Problem: 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)

Rate this tip 1 2 3 4 5   RATING: 2.41   VIEWS: 11510 Email Tip Print Tip Add to My Tips

READER COMMENTS (view all comments)

I NEED UR HELP SRINIVASAN wrote on December 31, 1969 19:00 EST I AM UNABLE TO UNDERSTAND THE COMMAND "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)". WOULD U HELP ME PLZ. vlookup ghulam raza wrote on December 31, 1969 19:00 EST 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.

REGISTERED USERS - Click here to post comments GUESTS (Click here to register) Name Comment Title Comments

Business Plans For Dummies® Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002 Wall Street Journal Guide to Understanding Money and Investing The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers Special Edition Using Microsoft Excel 2002 The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner

RELATED MICROSOFT EXCEL TIPS

Create User Forms in Microsoft Excel Using Loops in VBA in Microsoft Excel The Best Shortcut Keys in Microsoft Excel Writing Your First VBA Function in Excel Add Combo Box to a Sheet in Microsoft Excel Formulas to calculate Loan payments in Microsoft Excel Array variables using VBA in Microsoft Excel Create an Amortization Schedule in Microsoft Excel Find duplicates items in combine columns in Microsoft Excel Vlookup Formula – Organizing the Data Table

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books