# Encoding a Sequence of Letters

1. ## I NEED UR HELP

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.

2. ## vlookup

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.

3. ## Encoding a Sequence of Letters

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)

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1