Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 23

Thread: formula to generate reordring or resorting from given word

  1. #11
    New Member
    Join Date
    Mar 2019
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: formula to generate reordring or resorting from givin word

    ok i get it a little more
    i reach to this give me error

    also i assume in other cell it should look like this.right?
    .=VLOOKUP(F1,mytable,2)
    .=VLOOKUP(F2,mytable,2)
    .=VLOOKUP(F3,mytable,2)
    .=VLOOKUP(F4,mytable,2)

  2. #12
    Board Regular
    Join Date
    Apr 2010
    Posts
    10,984
    Post Thanks / Like
    Mentioned
    13 Post(s)
    Tagged
    1 Thread(s)

    Default Re: formula to generate reordring or resorting from givin word

    lookups are correct, instead of concatenate use =f1&" - "&f2&" - "&f3&" - "&f4

    I should have explained that more clearly, sorry

  3. #13
    New Member
    Join Date
    Mar 2019
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: formula to generate reordring or resorting from givin word

    dont be sorry thanks for helping
    here results
    Code:
    http://ipic.su/img/img7/fs/11.1553012423.png
    it generate number not from word



    1 bear
    2 dog
    3 cat
    4 snake

  4. #14
    Board Regular
    Join Date
    Apr 2010
    Posts
    10,984
    Post Thanks / Like
    Mentioned
    13 Post(s)
    Tagged
    1 Thread(s)

    Default Re: formula to generate reordring or resorting from givin word

    there is no dot in front of =vlookup otherwise I do not know why you are unable to replicate my worksheet and macro

  5. #15
    New Member
    Join Date
    Mar 2019
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: formula to generate reordring or resorting from givin word

    there is a . in front of =vlookup

  6. #16
    Board Regular
    Join Date
    Apr 2010
    Posts
    10,984
    Post Thanks / Like
    Mentioned
    13 Post(s)
    Tagged
    1 Thread(s)

    Default Re: formula to generate reordring or resorting from givin word

    the syntax is =vlookup(f1,mytable,2)

  7. #17
    Board Regular
    Join Date
    Apr 2010
    Posts
    10,984
    Post Thanks / Like
    Mentioned
    13 Post(s)
    Tagged
    1 Thread(s)

    Default Re: formula to generate reordring or resorting from givin word

    the dot is a typo - sorry

  8. #18
    New Member
    Join Date
    Mar 2019
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: formula to generate reordring or resorting from givin word

    its give formula you typed contains error
    the syntax is =vlookup(f1,mytable,2)
    Last edited by newbexcell; Mar 20th, 2019 at 03:07 PM.

  9. #19
    Board Regular
    Join Date
    Apr 2010
    Posts
    10,984
    Post Thanks / Like
    Mentioned
    13 Post(s)
    Tagged
    1 Thread(s)

    Default Re: formula to generate reordring or resorting from givin word

    have you defined mytable ?

  10. #20
    New Member
    Join Date
    Mar 2019
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: formula to generate reordring or resorting from givin word

    Quote Originally Posted by oldbrewer View Post
    have you defined mytable ?
    this is what i added

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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