# Thread: formula to generate reordring or resorting from given word Thanks:  8 Post #5244301 (1)Post #5244876 (1)Post #5244519 (1)Post #5245194 (1)Post #5244630 (1) Likes:  6 Post #5244876 (1)Post #5245194 (1)Post #5244301 (1)Post #5246231 (1)Post #5244679 (1)

1. ## 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. ## 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. ## 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. ## 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. ## Re: formula to generate reordring or resorting from givin word

there is a . in front of =vlookup

6. ## Re: formula to generate reordring or resorting from givin word

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

7. ## Re: formula to generate reordring or resorting from givin word

the dot is a typo - sorry

8. ## Re: formula to generate reordring or resorting from givin word

its give formula you typed contains error
the syntax is =vlookup(f1,mytable,2)

9. ## Re: formula to generate reordring or resorting from givin word

have you defined mytable ?

10. ## Re: formula to generate reordring or resorting from givin word

Originally Posted by oldbrewer
have you defined mytable ?