Vlookup

[skinner9]

I cut and pasted data in ms word, then imported into ms excel. I have 2 simple columns. Vlookup will not work except for the frist line. Anything past the 1st line is like it is not there. Tested by manuallY entering same data in another sheet. Vlookup worked fine. Tried cutting and pasting whole sheet to another sheet. Still no luck. Any ideas?

 

[Jonmo1]

Welcome to the board..

Without seeing sample data, and formula you used..
Best guess is "Numbers Stored As Text"

Try copying any blank cell
Then highlight the range of data that you copied/pasted from word
Right click - Paste Special - Values - ADD
Click OK.


Hope that helps.

 

[skinner9]

I did that already. Still does not work. I am not using any numbers. My 1st column is a list of acronyms, 2nd column...what the aconym stands for.