Forum Discussion
how do we fill in school.xlsx file age column from age.xlsx file by using name column with visual b
how do we fill in school.xlsx file age column from age.xlsx file by using name column with visual basic excel? Tables have variable length and have more than 10000 rows. school.xlsx |A | B | C| ...
sergey989 Why VBA? A simple VLOOKUP or INDEX/MATCH (or XLOOKUP if your Excel version supports it) can do this.
can you show me example?
but we have variable length column
but we have variable length column
sergey989 See attached example. I chose to put the data in structured tables. All three lookup methods are in the table at the top under age1, age2 and age3.
See if you can get it to work on your side.
can we make in two different files and very large and very large variable length table?
sergey989 Yes you can. Look at the MS support pages for the function you want to use and follow the instructions there. Not much more I could do than repeat what has been written there already.