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...
=INDEX($B$2:$B$6,SMALL(IF($A$2:$A$6=A9,ROW($A$2:$A$6)-1),COUNTIF($A$9:A9,A9)))Those who have e.g. Excel 2013 can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
Thank you, I have tried this formula, it's working.