Forum Discussion
Need Excel functionality for the random sequence Vlookup
Hi Expert guys, I need Excel functionality with the below data. 1st table contains the below data. 1) 1st table. 2nd table(as below data) - 1st column contains the random arr...
It might help us help you if you could explain the bigger picture here. Is it possible to tell us what the real data are about? If not, still would help if we understood more....
I say that because in many ways your first table looks quite random, so one wonders (this one does, at any rate) why not just make everything random altogether?
If you can't tell us more about the context itself, let me ask these:
- I notice that even though the series of letters has changed "randomly," the sequence of values connected with "a" is still the same as in "Raw Data" -- i.e., 1,2,5. Is that essential, or could those values be randomly sequenced, e.g., 2, 5, 1?
- wouldn't it be more random if those values associated with "a" were randomly sequenced?
- How many rows are there in your real tables?