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...
See the attached workbook. I added a helper column to the raw data with RAND() formulas.
The 2nd table uses INDEX and SORT to create a list in random order.
Press F9 to create a new randomized result.
- Got it, but I see the error in column 1 and 2 as below.
Request you help here.
Column 1 Column 2 Helper Column 1 Column 2
a 1 0.143551864 #NAME? #NAME?
a 2 0.736334881 #NAME? #NAME?
b 3 0.603049822 #NAME? #NAME?
c 4 0.611444202 #NAME? #NAME?
a 5 0.475457091 #NAME? #NAME?
