Need help with 1 simple Index Match formula.

[lorenc1]

Hello. I am trying to show the word ( text ) from the left combined/matched with the number to the right. I am trying to randomize the words ( that will show up below ) based on the random numbers on the right.

I am sorry for complicating it so much but i am really really new to this.

Ask me any question and i will and explain what i am trying to do.

Thanks in advance.

[Pete_UK]

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Pete

[Phuocam]

Try this ...

=INDEX($A$2:$A$12,H2)

Or:

=INDEX($A$2:$A$12,RANDBETWEEN(1,ROWS($A$2:$A$12)))

[Czeslaw]

Apply the formula

Please Login or Register  to view this content.

[lorenc1]

Thank you very much. 2nd formula worked like a charm.

[lorenc1]

Try this ...

=INDEX($A$2:$A$12,H2)

Or:

=INDEX($A$2:$A$12,RANDBETWEEN(1,ROWS($A$2:$A$12)))

I know i marked the post as [solved] but i got couple more questions. Is there any chance that on this formula (=INDEX($A$2:$A$12,RANDBETWEEN(1,ROWS($A$2:$A$12))) exists some other line so the words i am using do not repeat themselves twice or more times in a row?