I have two excel files. I am trying to copy data from one file (source file) to another (destination) using VLOOKUP function using a column of values present in both the files. The problem is some of these values in the source file are stored as TEXT and hence, I am getting an N/A error while using VLOOLUP (all these values in destination file are numbers). I tried to use format and change everything in the source file to number but still it doesn't work. Can someone please help me how to handle this?

Also, when I change the values in the destination file, will the VLOOKUP function automatically look for the corresponding values from the source file and change the values? Thanks.