+ Reply to Thread
Results 1 to 3 of 3

Encoding a Sequence of Letters

  1. #1
    SRINIVASAN
    Guest

    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. #2
    ghulam raza
    Guest

    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. #3
    Forum Contributor
    Join Date
    12-07-2004
    Posts
    596

    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)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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