USING VLOOKP TO IMPORT DATA FROM ONE WORKSHEET TO ANOTHER

[TIYOYO]

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]

 

[stanleydgromjr]

Welcome to the forum.

You posted the following formula:
=VLOOKUP(B3,TEST!A3:0983,7,FALE)

0983 should probaly be O983
and
FALE should be FALSE

Try:
=VLOOKUP(B3,TEST!A3:O983,7,FALSE)


Have a great day,
Stan

 

[Brian from Maui]

Re: USING VLOOKP TO IMPORT DATA FROM ONE WORKSHEET TO ANOTHE

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]

Check for leading/trailing spaces in your imported data in your lookup column. I'm assuming it's a typo of your formula as you wouldn't be able to enter the formula like that.