I would like to import data downloaded from a text file into an existing excel worksheet. I saved the text file as an excel worksheet. When I use the vlookp up function to compare the unique identifier for each row I keep getting the same error message #NA. I have reformated the columns from both spreadsheet to be the same. the function I am using =VLOOKUP(B3,TEST!A3:0983,7,FALE). Is the problem with the text file, although it was converted to excel? Does anyone have any suggestions.
Thank you.[/b]
Thank you.[/b]