Dec 22 2020 07:09 PM
Is there anyone who can help me to pass this exam on Vlookup, thanks so much~
Dec 22 2020 07:28 PM
what's the problem for this formula?
=VLOOKUP(SUMIF(学习安排表!$B$2:$B$23,A2,学习安排表!$D$2:$D$23),等级对照表!$A$2:$B$5,2,TRUE)
Dec 22 2020 09:28 PM
Solution@hiker7457 Change the table in the second sheet like in the picture below (highlighted in yellow). Then it shall work.
Feb 01 2021 12:21 AM
Dec 22 2020 09:28 PM
Solution@hiker7457 Change the table in the second sheet like in the picture below (highlighted in yellow). Then it shall work.