Forum Discussion
how do we fill in school.xlsx file age column from age.xlsx file by using name column with visual b
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.
but excel stall when i copy large columns .
=ЕСЛИОШИБКА(ВПР([@[name ]];tblAge;2;0);"Not found")
Can we put this code in vba macros and how to make faster?
sergey989 Please provide a bit more info, otherwise we will go back and forth without achieving anything. Perhaps you can upload some files that are like your real ones and then I can perhaps enter the required formulae. From Google translate I understand that you are going for "ВПР" = VLOOKUP
sample two files
how do we fill in school.xlsx file age column from age.xlsx file by using key name column with visual basic excel? Tables have variable length and have more than 10000 rows.
school.xlsx
sergey989 Two files attached. This time I just used the data as you provided it. Didn't bother to create structured tables. You need to have both files open.