nguyenthehoat
New Member
- Joined
- May 2, 2002
- Messages
- 15
I 'm using windows Xp and office XP.
working in ware house section I have to control about 3000 kind of material. I usually use vlookup formula, it is very convenient but unfortunately, sometime data format in sheets automatically change to different type so my formula can not work correctly."#N/A". If I copy vlookup value from table ray it will return correct value. I tried to format vlookup value and the value in table ray in the same type (text, general,number) but my formula still doesn't work. It will take some months to input this data again. Please help me fix this problem.
Many thanks in advance.
Mr.The Hoat
Yazaki Haiphong,Vietnam
working in ware house section I have to control about 3000 kind of material. I usually use vlookup formula, it is very convenient but unfortunately, sometime data format in sheets automatically change to different type so my formula can not work correctly."#N/A". If I copy vlookup value from table ray it will return correct value. I tried to format vlookup value and the value in table ray in the same type (text, general,number) but my formula still doesn't work. It will take some months to input this data again. Please help me fix this problem.
Many thanks in advance.
Mr.The Hoat
Yazaki Haiphong,Vietnam