Problem with Text format

**vioravis** · 09-10-2007, 07:24 PM

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.

**NBVC** · 09-10-2007, 07:47 PM

Select the column in the source file (ie. the 1st column referenced in your Vlookup) and go to Data|Text to Columns....click Finish...this should change the text values to General.