SOLVED

vlookup formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2011373%22%20slang%3D%22zh-CN%22%3Evlookup%20formula%E3%80%82%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2011373%22%20slang%3D%22zh-CN%22%3E%3CP%3EIs%20there%20anyone%20who%20can%20help%20me%20to%20pass%20this%20exam%20on%20Vlookup%2C%20thanks%20so%20much~%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2011373%22%20slang%3D%22zh-CN%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2011419%22%20slang%3D%22zh-CN%22%3EReply%3A%20vlookup%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2011419%22%20slang%3D%22zh-CN%22%3E%3CP%3Ewhat's%20the%20problem%20for%20this%20formula%3F%3C%2FP%3E%3CP%3EVLOOKUP%20(SUMIF!%24B%242%3A%24B%2423%2C%20A2%2C%20Study%20Schedule!%24D%242%3A%24D%2423)%2C%20Level%20Control%20Table!%24A%242%3A%24B%245%2C2%2CTRUE)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2011542%22%20slang%3D%22en-US%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%20vlookup%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2011542%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F909948%22%20target%3D%22_blank%22%3E%40hiker7457%3C%2FA%3E%26nbsp%3BChange%20the%20table%20in%20the%20second%20sheet%20like%20in%20the%20picture%20below%20(highlighted%20in%20yellow).%20Then%20it%20shall%20work.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-12-23%20at%2006.27.15.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F242484i84056D08B636D057%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202020-12-23%20at%2006.27.15.png%22%20alt%3D%22Screenshot%202020-12-23%20at%2006.27.15.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Is there anyone who can help me to pass this exam on Vlookup, thanks so much~

4 Replies

what's the problem for this formula?

=VLOOKUP(SUMIF(学习安排表!$B$2:$B$23,A2,学习安排表!$D$2:$D$23),等级对照表!$A$2:$B$5,2,TRUE)

 

best response confirmed by hiker7457 (New Contributor)
Solution

@hiker7457 Change the table in the second sheet like in the picture below (highlighted in yellow). Then it shall work.

Screenshot 2020-12-23 at 06.27.15.png

Thanks so much Sir, it really helps me.