Thread: Dynamically displaying cells based on a random number

When you say text values you mean numbers from 1 to 100 yes? What your asking for is just returning the same number that is in A1 correct?

=VLOOKUP(A1;A2:A100;1;0)

If you just want to duplicate the number you could make B1=A1.

If I'm missing something could you post the spreadsheet? Did you want to know the cell reference instead?

Does this work:

=INDEX(A2:A100,A1)

Originally Posted by darknation144

When you say text values you mean numbers from 1 to 100 yes?

Not quite. They're words. String values, I think they're often called?

Anyway, here's the sheet - I was using A1, A2 etc for simplicity's sake, the actual values are:
B7 - the random number generator
B22-B121 - The list of words
D7 - the place where I'd like the result

npc-personality-traits.xls

You need to use Index and Match.

The INDEX solution I put forward earlier works with words.

npc-personality-traits.xls

Hope this works I wrote this on calc but hopefully I changed all the ; to ,

Didn't seem to work basically here is the code

=INDEX($B$22:$T$121,MATCH(B7,$A$22:$A$121,0),MATCH(C7,$B$20:$T$20,0))

Originally Posted by darknation144

Attachment 137926

Hope this works I wrote this on calc but hopefully I changed all the ; to ,

Didn't seem to work basically here is the code

=INDEX($B$22:$T$121,MATCH(B7,$A$22:$A$121,0),MATCH(C7,$B$20:$T$20,0))

This worked excellently! Thanks so much for all of your help, everyone!