Forum Discussion

Copper Contributor

Aug 14, 2023

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...

developer

excel

Excel for web

Formulas and Functions

Silver Contributor

Aug 14, 2023

Hi nagavardhan1122

Based on the sample you provided that could be:

in F3:

=INDEX(
  FILTER(Table1[Number],Table1[Letter]=[@Letter]),
  COUNTIF(E$3:E3,E3)
)

nagavardhan1122
Copper Contributor
Oct 25, 2023
Thank you, I tried it in Microsoft 365 web. It's working.