M
Mark
I have a problem and don't know what to do anymore, I'm stuck.
Here is the it is:
I have a workbook with two worksheets where sheet1 has data
in column A and B. A is employee's pass number (6 digits) B is last
name. On sheet2 I have vlookup formula that tells excel to enter
employee's last name (cell B1) when I enter his pass number in cell
A1. I made this workbook at home so I made up some numbers and names,
put them on sheet1 and everything worked.
Now I took it to work and here I had to take data from Wang system
using file transfer program which gives me .txt file on a PC.
I opened this .txt file with excel (on separate workbook because I
had to do some cleanup first) then copied it into my sheet1and now
with most of those pass numbers when I enter them in A1 on sheet2 give
#NA error instead of last name. Some of them work though.
I have column A formatted as text because some of those numbers start
with zeros. I was playing with formatting (text, general) on both
sheets and nothing works.
There is only one thing that hit me now and I didn't try at work.
What happens if I retype those numbers on sheet1 and reenter them on
sheet2. If that works (I'll try tomorrow) then I don't know what to
think of it.
Can somebody help me whit this, please
Mark
Here is the it is:
I have a workbook with two worksheets where sheet1 has data
in column A and B. A is employee's pass number (6 digits) B is last
name. On sheet2 I have vlookup formula that tells excel to enter
employee's last name (cell B1) when I enter his pass number in cell
A1. I made this workbook at home so I made up some numbers and names,
put them on sheet1 and everything worked.
Now I took it to work and here I had to take data from Wang system
using file transfer program which gives me .txt file on a PC.
I opened this .txt file with excel (on separate workbook because I
had to do some cleanup first) then copied it into my sheet1and now
with most of those pass numbers when I enter them in A1 on sheet2 give
#NA error instead of last name. Some of them work though.
I have column A formatted as text because some of those numbers start
with zeros. I was playing with formatting (text, general) on both
sheets and nothing works.
There is only one thing that hit me now and I didn't try at work.
What happens if I retype those numbers on sheet1 and reenter them on
sheet2. If that works (I'll try tomorrow) then I don't know what to
think of it.
Can somebody help me whit this, please
Mark