Office 2013 and Office 365 ProPlus - Vlookup でエラーが返ってこない

%3CLINGO-SUB%20id%3D%22lingo-sub-3005098%22%20slang%3D%22ja-JP%22%3EOffice%202013%20and%20Office%20365%20ProPlus%20-%20Vlookup%20does%20not%20receive%20errors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3005098%22%20slang%3D%22ja-JP%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20feel%20that%20the%20system%20is%20strange%2C%20but%20I%20was%20just%20asked%20to%20repair%20it%2C%20and%20the%20rest%20was%20guided%20here%20from%20support.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%2C%20the%20Vlookup%20issue%20is%20taking%20the%20SKU%20from%20the%20source.%20The%20result%20that%20the%20item%20which%20should%20be%20returned%20by%20the%20error%20(N%2FA)%20to%20the%20one%20not%20in%20the%20source%20brings%20the%20SKU%20of%20the%20cell%20immediately%20above%20is%20not%20understood.%20It%20takes%20time%20to%20notice%2C%20and%20I%20am%20troubled%20by%20this%20condition.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Nonk08_0-1637836341076.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329403i32FD36C012DD86F6%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Nonk08_0-1637836341076.png%22%20alt%3D%22Nonk08_0-1637836341076.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20also%20a%20problem%20with%20CSV%20saving%20is%20strange.%3C%2FP%3E%3CP%3EIf%20you%20can't%20heal%20well%2C%20you%20can't%20trust%20and%20use%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20should%20I%20do%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3005098%22%20slang%3D%22ja-JP%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

 

システムがおかしい気がするのですが、リペアをかけてもらっただけで、あとはサポートからこちらへ誘導されました。

 

まず、Vlookupの問題ですが、ソースからSKUを取ってきます。ソースにないものにエラー(N/A)で返すべき項目が、すべてすぐ上のセルのSKUを持ってくるという、わけのわからない結果がでます。気が付くのに時間がかかりまして、この状態に困っています。

 

Nonk08_0-1637836341076.png

 

他にも、CSVのセーブがおかしい問題もあります。

しっかり治せないと、信頼してエクセルを使えません。

 

どうしたらいいでしょうか?

 

0 Replies