Help me

nguyenthehoat · May 6th, 2002, 02:46 AM

Dear My friend,
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

Chris Davison · May 6th, 2002, 04:48 AM

what's the formula where you get "#N/A" error ?

edit - I see this is the 3rd time this question has hit the board....

Can this particular thread be locked ?

[ This Message was edited by: Chris Davison on 2002-05-06 04:07 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 6th, 2002, 02:46 AM	#1
nguyenthehoat New Member Join Date: May 2002 Location: Yazaki Haiphong,Vietnam Posts: 15	Dear My friend, 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

May 6th, 2002, 04:48 AM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	what's the formula where you get "#N/A" error ? edit - I see this is the 3rd time this question has hit the board.... Can this particular thread be locked ? [ This Message was edited by: Chris Davison on 2002-05-06 04:07 ]